This page is included in the project [[Leveraged Buyout Innovation (Academic Paper)]]
==Work Scripts==
===SQL===
*<code>E:\McNair\Projects\LBO\LBO academic paper patent data script pre compustat</code>
*<code>E:\McNair\Projects\LBO\LBO academic paper script post compustat</code>
===Stata===
==Work Description==
===LBO Data and Patent Data===
See script for exact work: <code>E:\McNair\Projects\LBO\Patent Data Scriptpatent data script</code>
*Get the source file for the LBOs
*'''statastaging''' with all variables from compupatentlboyearsummary in addition to all the pulled compustat variables
*'''sicnaicsconversion''' with sic codes and naics codes as a conversion table for adding naics that correspond to the sic codes in blank rows. Table from https://www.census.gov/eos/www/naics/concordances/concordances.html
*'''statastagingnew''' with two extra columns, concordsic and concordnaics, then export to stata
RE -- Retained Earnings
==ResourcesSQL Fixes==WRDS USER(Moved here from deleted page: mcnairLBO Fix List)WRDS PASS: 9Mil2015*Improve SIC to NAICS fill in further**Manually add in conversions from three digit SIC (e.g., 1110) to three digit NAICS (e.g., 134)**Re-import into STATA
http://www.axial.net/forum/how-private-equity-screens-lbo-candidates/ - Variables that private equity firms examine to decide whether or not to lbo