Import the matches into the dbase and generate the patent statistics using PatentMeasures.sql. Note that it is not possible to generate the patent measures for all of Compustat -- the data is just too big.
Then run AnalysisIn PatentMeasures.dosql*We are using all citations, not citations_cleaned, as the all cited and citing are bigint in citations. This means we have higher counts this time around.*Originality is based on citations received and generality is based on citations made. There may have been an error in originality in the previous version (hard to tell - misnamed tables)*The Match5yrCites table is big: 170,169,703 obs -- it is the explorative/exploitive measures that are very hard to build. The citation measures could likely be built for every CS firm 1974-present.*Ultimately creates: MatchedMeasuresPortfolioV2-1.txt
Then run Analysis.do. The current versions of the datasets with their origins are:
*Datasetup.do -> MatchInput2V1.txt -> LBOmatchscript.jl -> matchresults.txt -> matchresultsV2-1.dta
*Datasetup.do -> MatchInput2V1.txt -> LBOmatchscript.jl -> matchresults.txt -> PatentMeasures.sql (on dbase lbo)-> MatchedMeasuresPortfolioV2-1.txt -> PatentStatisticsV2-1.dta
*Datasetup.do -> PreMergeRelevantV2-1.dta
*CPI.dta
To do: Go back and fix the matching so that firms with CS data in t-2 still patent match in t-1.
====Catching the one unmatched====