第一次用循环,想要读取一个excel里的多个sheet,我把每一个sheet都按照年份命名,想要用这个年份作为循环的变量。但是发现stata报语法错误,所以想请教一下大家。代码如下
clear
global sheet 2016 2015 2014
forvalues i in $sheet {
import excel "C:\Users\johnhean\Desktop\能源\受教育程度\汇总.xlsx", sheet(`i') firstrow clear
replace province=subinstr(province," ","",.)
gen averag = 0
replace averag = (6*six + 9*nine + 12*twelve + 15*fifteen + 16*sixteen + 19*nineteen)/100
rename averag `i'
keep province `i'
save C:\Users\johnhean\Desktop\能源\受教育程度\`i',replace
}