7,627
edits
Changes
Jump to navigation
Jump to search
The Effect of Leverage Buyouts on Innovation (view source)
Revision as of 15:32, 25 June 2019
, 15:32, 25 June 2019→Analyzing DataExtension.sql
Key stacks:
*'''StataStaging4 ''' is an input
*gvkeyyearpatentdata (395213)
*statastaging4, (statastaging4->) LBOSeriesProcessed (556) -> LBODetailsWDurr (1691834)
Key stacks:
*'''patentexpiry''' is an input
*cspatentbuys FROM 'cspatentbuys.txt' (304864), which came from usptopad
*cspatentsales FROM 'cspatentsales.txt' (451730), which came from usptopad
*'''stdcompnames''' is an input*'''assignees ''' (is an input) -> Patentsassigneessimple 5426556
*(Patentsassigneessimple,MatchOrgnameSelf (loaded from orgnamedctmatched.txt 501232), MatchstdcompnamedctOrgname (loaded from Matchstdcompnamedctorgnamestd.txt 8361,stdcompnames) -> patentgrantgvkey
*patentgrantgvkey (1329006), cspatentbuysutlgvkey (272620) ... -> patentgrantbuy
*(patentgrantbuy,patentsale,patentexpired)-> patenthistorybase (1513045) *patenthistorybase ...,GvkeyYear -> gvkeyyearpatentdata (395213) Therefore needed inputs are:*patentexpiry*stdcompnames*assignees*StataStaging4
==Ed's version from 2018==
