文章预览
前情回顾 数据来源 清洗数据 cd C : \ Download
u id_inventor_id , clear
merge 1 : 1 id using id_patent_num , nogen
merge 1 : 1 id using id_appyear , nogen
drop id
sa _ , replace
*
u _ , clear
su a , d
loc m = r ( min )
loc n = r ( max )
forv i = ` m '/`n' {
u _ , clear
keep if inrange ( a , ` i '-2,`i' )
drop a
duplicates drop
g year = ` i '
sa _ ` i ', replace
}
*
u _ , clear
su a , d
loc m = r ( min )
loc n = r ( max )
forv i = ` m '/`n' {
u _ ` i ', clear
ren i z
drop y
joinby p using _ ` i '
drop if i == z
keep i z
duplicates drop
g year = ` i '
sa _ ` i '_iz, replace
g n = 0
collapse ( count ) n , by ( i )
g year = ` i '
sa _ ` i '_, replace
}
*
u _ , clear
su a , d
loc m = r ( min )
loc n = r (
………………………………