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
Exporting Oster bound estimatesDear all, As a robustness check, I'm computing the Oster bounds on unobservables for a range of out…
Filtering out cases in panel dataHi all, I am working with panel data and I need some helping filtering out the cases I can use. Eve…
Interaction term in a quadratic modelMy basic cross-sectional (countrywise) model is based on regress life_exp gdp_pc_ppp sq_gdp_pc_ppp N…
Autocorrelation and other assumptions Diff in Diff modelHello, I am working on the following Diff in diff model: ln_sales = b0 + b1*treatment + b2*(treat…
Creating Variable based on NAIC Digit Level match for FirmsI have a list of firms that I am comparing to each other. Next I want to compare the NAIC code of ea…
Subscribe to:
Post Comments (Atom)
0 Response to Importing Excel Files into stata
Post a Comment