7,627
edits
Changes
Jump to navigation
Jump to search
The Effect of Leverage Buyouts on Innovation (view source)
Revision as of 18:17, 28 June 2019
, 18:17, 28 June 2019→Moving Forward
**addzip, city, loc, prcc_f, ipodate, fyear
**act, artfs, at, ceq, che, csho, dlc, dltt, dvt, dvc, dvp, ebitda, emp, esubc, ibc, intan, lct, lt, ni, oibdp, opiti, re, revt, sale, txditc, txt, xidoc, xint, xrd, xsga, xstfws
===LBO data===
The LBO data is being drawn from a spreadsheet provided by Brian. The latest version is 484_LBOs_Outcomes_Master_Table.xlsx
Ed took the following columns:
dealnumb fyear gvkey name goprdt extdt1 exttype1 sic
Other columns were excluded because they were either constant across records or derivative. In addition, one record, Aurora Electronics Inc, was excluded as it didn't have a GVKEY.
The GVKEYs have been through Excel, which treated them as numbers and omitted their leading zeros. They will have to loaded as text and then reprocessed as follows:
SELECT LPAD(gvkey::text, 6, '0') as gvkey
===Code===
