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
ppml_panel_sg estimator: fixed effectsHi, I am using the ppml_panel_sg estimator for a gravity model with fixed effects (exporter-time, i…
Overlay graphs in Panel data without -collapse- or creating by group averagesHi, If we collapse data, we essentially create new data set containing averaged values. By creating…
How to create a simple table with my own specifications?Hi, I want to create my own table with column names and observations in stata. I have been searchin…
How to recover stored results from e() class?Hello, I am working on mwitch command of Stata. I work in Stata 15. I ran the following: . mswitch …
Counting the occurrence of “directors name”Hello respected experts, I am counting the number of times the same director has served on a board,…
Subscribe to:
Post Comments (Atom)
0 Response to Importing Excel Files into stata
Post a Comment