Changes

Jump to navigation Jump to search
Basic outline is as follows:
*Imported COMPUSTAT Data
**Built composite primary key from unique gvkeys crosscartesian-producted with years 1970 to 2015 (all other datasets will be joined onto this)
**Stripped out list of unique company names from COMPUSTAT data
**Used matcher to construct standardized company names, with lookup table to original names
**Sheet 3 contains COMPUSTAT output (unused)
**Sheet 4 contains private-to-private LBOs
*Use Used SDC data to flag LBO events for COMPUSTAT data
**Joined sheets 1 and 2 to link gvkey to each LBO deal
**Joined resulting table to composite key to flag for LBO occurrences in given year-gvkey combination
**Note: this leaves many LBOs unmatched. Applying name-based matching to include more (esp. all private-to-private)
==STATA analysis==

Navigation menu