Hi, Below is my code, and it always generates a warning: "unmatched quote r(198)." How can I resolve this issue?
global sheets "A" "B" "C" "D" "E"
foreach sheet in $sheets {
forvalues i=2016(1)2022 {
import excel "$DR//`i'.xlsx",clear sheet("`sheet'(`i')") firstrow
foreach v of var * {
cap replace `v' = "." if `v' == "--"
cap destring `v', replace
}
gen year=`i'
save $DT//temp_`i',replace
}
use $DT//temp_2016,clear
forvalues i=2016(1)2022 {
append using $DT//temp_`i'
}
save $DT//`sheet'.dta,replace
forvalues i=2016(1)2022 {
cap erase $DT//temp_`i'.dta
}
}
global sheets "A" "B" "C" "D" "E"
foreach sheet in $sheets {
forvalues i=2016(1)2022 {
import excel "$DR//`i'.xlsx",clear sheet("`sheet'(`i')") firstrow
foreach v of var * {
cap replace `v' = "." if `v' == "--"
cap destring `v', replace
}
gen year=`i'
save $DT//temp_`i',replace
}
use $DT//temp_2016,clear
forvalues i=2016(1)2022 {
append using $DT//temp_`i'
}
save $DT//`sheet'.dta,replace
forvalues i=2016(1)2022 {
cap erase $DT//temp_`i'.dta
}
}
Comment