Changes

Jump to navigation Jump to search
=New Version=
 
==Working Notes==
 
James' rough notes are in E:\McNair\Projects\LBO\Working Notes. These are date ordered and more for James than anyone else.
 
Files are generally in
E:\McNair\Projects\LBO\Clean
 
Seperate code to build the patent stocks base type (start date, expiry date) is in:
Building the Patent Start End Table.sql
 
Note that this code is out of date and needs to be replaced.
 
LBO Innovation SQL Script.sql is the sql script to process the data
*Has comments on matcher use
*Note - Can't run this file!
**Needs dramatic clean up
**Patent expiration needs recalculating. See [[Patent Expiration Rules]]
*Bbase txt files (in and out) in Z:\LBO\Clean
*statastaging4.txt (current final dataset) is exported from allpatentsprocessed
 
To work with the data in STATA:
*Run STATAdatasetup4.do
**Takes statastaging4.txt (currently as dta)
**Makes that statastaging4.dta
*Run STATApredictLBOclean.do
**Takes statastaging4.dta
**Makes STATApredictLBOcleanb.dta (which has a bug fix over STATApredictLBOclean.dta)
**Also exports STATApredictLBOclean.txt, which contains just the variables relevant for the matching
 
The matching scripts (in Julia - run as admin to access modules) are in folder
E:\McNair\Projects\LBO\New matching
 
Note that the instructions below are for the old version. James has now fixed the matching script to export tab-delimited text of matches that can be merged back into a STATA dataset, so the diff-in-diff can be done in STATA.
 
The old version instructions are:
*From terminal in E:\McNair\Projects\LBO\New matching
*Launch Julia: julia
*Run script: include("LBODID.jl")
 
The old files are
 
LBODID.jl
Loads data from E:\McNair\Projects\LBO\Clean\STATApredictLBOclean.txt
Adds col, removes dead cases, breaks data into LBO & non-LBO
Line 55: mscore = :logitpw;
Lines 89-96: Define criteria for what constitutes a match - store as string evaluated for truth
Line 101: include("LBOmatching.jl") #Loading in user-defined methods for matching
Line 104: Do the matching!
Beyond line 105 are doing the diff-in-diff
==Introduction==

Navigation menu