Changes

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

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