7,627
edits
Changes
Jump to navigation
Jump to search
The Effect of Leverage Buyouts on Innovation (view source)
Revision as of 13:55, 4 July 2019
, 13:55, 4 July 2019no edit summary
The COMPUSTAT query will be (bold vars are those important to this paper):
*Jan 1975 to Sept 2018 July 2019 (latest allowed)
*'''GVKEY''', Entire Dbase
*Fields (Note that it was dvt not dt):
**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
This was pulled twice, with OPITI included the second time (which also went to July 2019). The results are in e28f8123921e8343.txt which are saved to Z:\lbo. The request summary was saved to E:\projects\lbo.
Data Request ID e28f8123921e8343
Libraries/Data Sets compa/funda /
Frequency/Date Range ann / 01Jan1975 - 31Jul2019
Search Variable GVKEY
Input Codes
all item(s)
-all-
Conditional Statements n/a
Output format/Compression tab /
Variables Selected CONM TIC CUSIP EXCHG FYEAR ACT ARTFS AT CEQ CEQL CHE DLC DLTT INTAN LCT LT RE TXDITC DVC DVP DVT EBITDA NI OIBDP OPITI REVT SALE TXT XINT XRD XSGA XSTFWS ESUBC IBC XIDOC CSHO EMP PRCC_F
Extra Variables and Parameters Selected C INDL FS STD
===LBO data===
Database is '''lbo''' and dbase server directory is /bulk/lbo
The COMPUSTAT query is saved on the mcnair (AmoDate) account, and the last result is saved as 1caad330ae9d095fe28f8123921e8343.txt
The output of this SQL code is:
