Changes

Jump to navigation Jump to search
377 bytes added ,  17:44, 5 October 2020
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
===Introduction of Compustat and Preparation for Stata===
See script for exact work: <code>E:\McNair\Projects\LBO\LBO academic paper script post compustat</code>
 
Create tables as follows:
*sdc '''SDC''' with SDC data imported from the initial LBO data.
*'''LBOCOMPUSTAT4 ''' with Compustat data imported.
*'''dealnumbxgvkey ''' selecting deal numbers and gvkeys from table sdc.
*'''compustatnamematch ''' with compustat names matched against themselves imported
*'''stdcompnamestdorgnamematched ''' with standardized compustat names matched against stdorgname
*'''matchedlbocompnames ''' with standardized original lbo names matched to standardized compustat names
*'''compnamematchlbocompnames ''' with standardized compustat names, compustatnames, and standardized original lbo names
*'''stdcompnamepatentjoin ''' with variables standardized compustat names and patent numbers
*'''compustatpatentinfo ''' with variables standardized compustat names, patent numbers, and grant dates
*'''stdcompnamexgvkeycleaned ''' with variables standardized compustat names and gvkeys
*'''ALLGVKey ''' with all distinct gvkeys from stdcompnamexgvkeycleaned
*'''AllYears ''' with all years from 1970 to 2016
*'''KeysXYears ''' with variables gvkey and year. Each gvkey corresponds to 47 years.
*'''keysxyearsxstdcompname ''' with variables gvkeys, years, and standardized compustat names
*'''compupatentyearsummary ''' with variables standardized compustat names, gvkeys, years, and number of patents per year
*'''dealnumbxgvkeyxlboyeartemp ''' with variables deal numbers, gvkeys, LBO years, and exit years
*'''dealnumbxgvkeyxlboyear ''' with variables deal numbers, gvkeys, lbo years, exit years, entry year 1, entry year 2, exit year 1, and exit year 2
*'''compupatentlboyearsummary ''' with variables standard compustat names, gvkeys, years, number of patents per year, and lbo entries/exits in each year
*'''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
===Stata Work===
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
[[category:Internal]]

Navigation menu