已解决，改动了一下可以了
clear
global sheet  2019 2018 2017 2016 2015 2014 2013 2012 2011 2010        2009 2008 2007 2006
global sheet2  2018 2017 2016 2015 2014 2013 2012 2011 2010        2009 2008 2007 2006
foreach i in $sheet {
import excel "C:\Users\johnhean\Desktop\能源\受教育程度\汇总.xlsx", sheet(`i') firstrow clear
replace province=subinstr(province," ","",.)
gen averag`i' = 0
replace averag`i' = (6*six + 9*nine + 12*twelve + 15*fifteen + 16*sixteen + 19*nineteen)/100

keep province averag`i'
save C:\Users\johnhean\Desktop\能源\受教育程度\1`i',replace
}