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
Test for differences in Medians for Multiple Variables Using qregDear Stata Users: I would like to Test for differences in Medians for Multiple Variables Using qreg …
Panel data with fixed effects model having dummy/time-invariant variables in data setGreetings, I'm trying to conduct FE-model test on my panel data set. The panel consists of 116 comp…
Generating a new variable based on several specified conditionsDear Stata-Community, I am currently working on a paper in which I want to create a variable that in…
Specification of funnel plot with -funnelcompar-Hi Statalisters I want to assess county differences in medication rates in Norway to detect outlier…
Specification of funnel plot with -funnelcompar-Hi Statalisters I want to assess county differences in medication rates in Norway to detect outlier…
Subscribe to:
Post Comments (Atom)
0 Response to Importing Excel Files into stata
Post a Comment