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
Program to calculate a percentile and rank by percentile and a factorI have a dataset that looks like this, 2 observations per id: id observation birth year diabetes …
Newey-West HAC standard errors smaller than regress, robust onesHi all, I am running an ARDL model in the form: Code: reg y l.y x1 l.x1 x2 l.x2 After the esti…
Panel dataHi everyone ,I have panel data from BHPS and i want to use descriptive statistics (one table and one…
Question for logistic regression analysisGreetings, If i have an ordinal dependend variable , which is a 5 scale likert skala and i want to …
FrequencyHi everyone, I want to calculate the cumulative frequency of firms which have different identifiers …
Subscribe to:
Post Comments (Atom)
0 Response to Importing Excel Files into stata
Post a Comment