数据来源:国泰安。清洗数据cd C:\Download\1
fs *.zip
foreach f in `r(files)'{
unzipfile `f'
}
*
fs *.xlsx
foreach f in `r(files)'{
import excel using "`f'" , firstrow clear
qui{
foreach v of var * {
la var `v' "`=`v'[1]'"
replace `v' = "" if _n == 1
}
drop in 1/2
cap ren Symbol Stkcd
cap g year = substr(EndDate,1,4)
cap g year = substr(DeclareDate,1,4)
cap order year
cap order Stkcd
qui foreach v of var * {
cap destring `v', replace
}
sca f_temp = "`f'"
loc fname = usubinstr(f_temp,".xlsx","",.)
compress
}
di ".........................................."
save "`fname'.dta", replace
d
cap g year = 0
ta year,m
}得到结果Contains data from br_businessrisk.dta
Observations: 240,522
Variables: 34 25 Apr 2024 10:20
-------------------------------------------------------------------------------------------------
Variable Storage Display Value
name type format label Variable label
----
………………………………