7,627
edits
Changes
Jump to navigation
Jump to search
The Effect of Leverage Buyouts on Innovation (view source)
Revision as of 19:10, 21 February 2018
, 19:10, 21 February 2018no edit summary
|Has paper status=In development
}}
=Current Work=
==Ed's version==
Files are in E:\McNair\Projects\LBO\Clean\Ed Run
The process:
#In dbase '''allpatentsprocessed''' on 181. Local files in Z:\LBO\Clean
##Run LBO Innovation SQL Script.sql sections 1,2, and 3A
##Run Building the Patent Start End Table Revised.sql
##Run LBO Innovation SQL Script.sql sections 3B, 3C, and 4. This produces statastaging5.txt.
#In STATA
##Run STATAdatasetup.do. It takes statastaging5.txt and produces STATAdataset5wvars.dta
##Run STATApredictLBOclean.do. It takes STATAdataset5wvars.dta and produces STATApredictLBOclean.dta and STATApredictLBOclean5.txt
#In Julia
##Run LBOmatchscript.jl. It takes STATApredictLBOclean5.txt and produces matchresults.txt
#In STATA
##Run PreMergePrep.do. It tales matchresults.txt and produces MatchResults.dta
##Run Merge.do. It takes STATApredictLBOclean.dta and merges it with MatchResults.dta. It then does the analysis.
See also: James New Run Documentation.txt This provides an overall summary, though some of the details are a little off.
==Adding Patent assignment data==
The patent assignement data is loaded into '''usptopad''' on the rdp (not the dbase server). The load script and processing script are in:
E:\McNair\Projects\USPTO Patent Assignment Dataset
The process script (ProcessAssignments.sql) was modified for this project:
*Create list of distinct or_name (from assignors) for inter firm assignments
*Create list of distinct ee_name (from assignees) for inter firm assignments
Build the patent data:
*DataExtension.sql
=New Version=
