668
edits
Changes
Jump to navigation
Jump to search
The Effect of Leverage Buyouts on Innovation (view source)
Revision as of 12:56, 5 July 2016
, 12:56, 5 July 2016→Introduction of Compustat and Preparation for Stata
===Introduction of Compustat and Preparation for Stata===
See script for exact work.
*Create table sdc with SDC data imported from the initial LBO data.
*Create table LBOCOMPUSTAT4 with Compustat data imported.
**Note: There were 3 prior Compustat pulls. The 1st is used to create several cross reference tables that are not made obsolete by the subsequent pulls.
*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 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
*
==Compustat Variables==
