前情回顾清洗数据cd C:\Download
*
import exc FI_T10, first clear
keep if regexm(Acc,"-12-")
g year = substr(Acc,1,4)
drop if mi(y)
keep Stkcd year F100801A
ren F MVE
destring *, force replace
save 0, replace
*
import exc CSR_Finidx, first clear
keep if regexm(Acc,"-12-")
g year = substr(Acc,1,4)
drop if mi(y)
keep Stkcd year Outcap
destring *, force replace
save 1, replace
*
import exc PT_LCRDSPENDING, first clear
keep if regexm(End,"-12-") & StateTypeCode == "1"
ren Sym Stkcd
g year = substr(End,1,4)
drop if mi(y)
destring *, replace
keep Stkcd year RDSpendSum
save 2, replace
*
import exc CD_CompOfDivProfitCo, first clear
drop in 1/2
ren DivdendY year
ren Symbol Stkcd
destring *, replace
bys Stkcd year: egen n = sum(DividendNum)
keep Stkcd year n
duplicates drop
g DIV = n > 0
drop n
save 3, replace
*
use fs_combas_annual_consolidate_new, clear
merge 1:1 Stkcd year using fs_comscfd_annual_consolidate_new, nogen
merge 1:1 Stkcd year using 行业代码_2022,
………………………………
