===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 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
*statastagingnew with two extra columns, concordsic and concordnaics, then export to stata