7,627
edits
Changes
Jump to navigation
Jump to search
==Ed's version from 2018==
The Effect of Leverage Buyouts on Innovation (view source)
Revision as of 12:30, 26 June 2019
, 12:30, 26 June 2019no edit summary
*New draw of the universe COMPUSTAT data, with all appropriate variables, covering 1975-2017 (or 2018 if possible), processed to remove duplicates etc.
*Imports of '''patenthistwoprebuys''' and '''gvkeyyearpatentdata''', which are available in '''allpatentsprocessed'''
*Import of '''sicnaicsconversion''', as we need the lookup table(s)
*Imports of '''patents''', '''citations''', and '''HistMasterFile''', all of which are available in '''allpatentsprocessed''' -- we can then run the code from PatentMeasures.sql to generate the merge data once we've done the matching.
*Also import '''assignees''', even though we won't be using it directly
Note that citations_cleaned (74,164,171) appears to be just citations (97,680,838) restricted to integer patent numbers but we are going to rebuild it anyway.
==Code==
The new code is in:
E:\projects\lbo\Buyouts.sql
Database is '''lbo''' and dbase server directory is /bulk/lbo
=Ed's version from 2018=
Files are in E:\McNair\Projects\LBO\Clean\Ed Run
