Changes

Jump to navigation Jump to search
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====

Navigation menu