Stata学习：CSMAR上市公司财务衍生报表数据库！

文章预览

数据来源：国泰安。 清洗数据 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 ( EndDate , 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 Typrep , m } 得到结果 Typrep [报表类型] - A＝合并报表期末 B＝母公司报表期末 C＝合并报表期初 D＝母公司报表期初 Contains data from stk_fin_cashflowindrectttm.dta Observations: 203,642 Var ………………………………