218
edits
Changes
Jump to navigation
Jump to search
The Effect of Leverage Buyouts on Innovation (view source)
Revision as of 16:51, 10 November 2016
, 16:51, 10 November 2016→Construction of Dataset (SQL)
**First used appropriate columns from sheet 2 to make preliminary lookup table
*Note: This left many LBOs unmatched. Applied name-based matching to include more deals (esp. all private-to-private)
**Copied dealnumb and company name from '''LBO_List_and_data.xlsx ''' into textpad**Manually removed extraneous symbols and words, saved result as '''LBO_Cleaned_data.xlsx'''
**Performed matching by company name with stdcompnames.txt (which included gvkeys) to get alternative gvkey-dealnumb lookup table
**Appended non-contradictory results to previous gvkey-dealnumb lookup table (to make SQL table '''gvkeyxdealnumbfinal''')
**Used this table to flag LBO events in Compustat dataset for appropriate gvkeys in appropriate year(s)
***Result is SQL table '''yearsbygvkeysfilled2'''
==STATA analysis==
