foreach file in 科创板首发数据 {
clear
import excel using "`file'.xlsx", clear
capture foreach x of varlist * {
              local vnam = `x'[1]
              rename `x' `vnam'
///                       
gen code=substr(证券代码,1,6)
gen year=substr(上市日期,6,4)
drop 证券简称 上市日期 证券代码
destring code year,replace
///
save `file'.dta, replace
}
}