清洗数据cd C:\Download\1
fs *.zip
foreach f in `r(files)'{
unzipfile `f'
}
*
fs *.xlsx
foreach f in `r(files)'{
import excel using "`f'" , first clear
qui{
foreach v of var * {
la var `v' "`=`v'[1]'"
replace `v' = "" if _n == 1
}
drop in 1/2
cap g year = substr(DeclareDate,1,4)
cap order year
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
ta year,m
}变量预览Contains data from uss_dividend.dta
Observations: 121,232
Variables: 13 28 Apr 2024 21:01
------------------------------------------------------------------------------------------------
Variable Storage Display Value
name type format label Variable label
------------------------------------------------------------------------------------------------
year int %1
………………………………
