7,612
edits
Changes
Jump to navigation
Jump to search
no edit summary
{{Project
|Has project output=Content
|Has sponsor=McNair Center
|Has title=LBO Data Description
|Has owner=James Chen,Brian Ayash,Ed Egan
|Has project status=Complete
}}
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==(Moved here from deleted page: LBO Fix List) *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
[[category:Internal]]
