Changes

*<code>E:\McNair\Projects\LBO\LBO academic paper patent data script pre compustat</code>

See script for exact work.: <code>E:\McNair\Projects\LBO\patent data script</code>

See script for exact work.: <code>E:\McNair\Projects\LBO\LBO academic paper script post compustat</code> Create tables as follows:

*Create table sdc '''SDC''' with SDC data imported from the initial LBO data.

*Create table '''LBOCOMPUSTAT4 ''' with Compustat data imported.

*Create table '''dealnumbxgvkey ''' selecting deal numbers and gvkeys from table sdc.

*Create table '''compustatnamematch ''' with compustat names matched against themselves imported

*Create table '''stdcompnamestdorgnamematched ''' with standardized compustat names matched against stdorgname

*Create table '''matchedlbocompnames ''' with standardized original lbo names matched to standardized compustat names

*Create table '''compnamematchlbocompnames ''' with standardized compustat names, compustatnames, and standardized original lbo names

*Create table '''stdcompnamepatentjoin ''' with variables standardized compustat names and patent numbers

*Create table '''compustatpatentinfo ''' with variables standardized compustat names, patent numbers, and grant dates

*Create table '''stdcompnamexgvkeycleaned ''' with variables standardized compustat names and gvkeys

*Create table '''ALLGVKey ''' with all distinct gvkeys from stdcompnamexgvkeycleaned

*Create table '''AllYears ''' with all years from 1970 to 2016

*Create table '''KeysXYears ''' with variables gvkey and year. Each gvkey corresponds to 47 years.

*Create table '''keysxyearsxstdcompname ''' with variables gvkeys, years, and standardized compustat names

*Create table '''compupatentyearsummary ''' with variables standardized compustat names, gvkeys, years, and number of patents per year

*Create table '''dealnumbxgvkeyxlboyeartemp ''' with variables deal numbers, gvkeys, LBO years, and exit years

*Create table '''dealnumbxgvkeyxlboyear ''' with variables deal numbers, gvkeys, lbo years, exit years, entry year 1, entry year 2, exit year 1, and exit year 2

*Create table '''compupatentlboyearsummary ''' with variables standard compustat names, gvkeys, years, number of patents per year, and lbo entries/exits in each year

*Create table '''statastaging ''' with all variables from compupatentlboyearsummary in addition to all the pulled compustat variables

*Create table '''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

*Create table '''statastagingnew ''' with two extra columns, concordsic and concordnaics, then export to stata

See script for exact work.: <code>E:\McNair\Projects\LBO\STATAdatasetup2</code> 

==ResourcesSQL Fixes==WRDS USER(Moved here from deleted page: mcnairLBO 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 STATAWRDS PASS: 9Mil2015

http[[category://www.axial.net/forum/how-private-equity-screens-lbo-candidates/ - Variables that private equity firms examine to decide whether or not to lboInternal]]