split 统计截止日期 ,parse(-) destring ignor("-")
rename 统计截止日期1 year
drop 统计截止日期3
drop if 统计截止日期2==1
gen quarter=int( 统计截止日期2/3 )
tab quarter
drop 统计截止日期2
gen yq=year*100+quarter
gen quarter2=yq(year,quarter)
format quarter2 %tq
tab quarter2
drop yq
rename quarter2 yq
order yq
我通常是这么做的