Hi I am using these commands to import the excel files and save them into stata.
but I am getting the error can anyone please help me to correct the issue.
local mylist 03 04 05 06 07 08 09 10 11 12
foreach x of local mylist {
import excel "E:\Health and air quality\December\Extract123\ZS_2000_"`i'".xls", sheet("ZS_2000_"`i'"") firstrow
keep DHSCLUST ZonalSt_sh
save "E:\Health and air quality\December\Extract123\ZS_2000_"`i'".dta", replace
}
Related Posts with Importing Excel Files into stata
How to overcome the word limitation of 12 in Stata output table when using esttab?I remember somewhere that the word limitation for variable name in Stata is 12, and I try with estta…
Fastest code for finding unique valuesI have a dataset of one million observation and have around 200 variables. I am struggling with find…
what does the size() option on bootstrap do?I apparently do not understand the documentation for the bootstrap command. Code: . sysuse auto, cl…
xtmixed command combined with by() or bysort()Dear Statalists, Is it possible to run xtmixed command by different criteria? For example, I have a…
Testing for serial correlation in panel analysis with instrumentDear all, Is there an alternative way to test for serial-/autocorrelation in a panel data setting w…
Subscribe to:
Post Comments (Atom)
0 Response to Importing Excel Files into stata
Post a Comment