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==
*'''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
==SQL 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]]
