Stata loop to retrieve data from Excel file

Question

My Excel file has many sheets. I am trying to create a loop to retrieve every sheet of data to be able to save it as .dta. This is my code:

local sheet = `" "Data dictionary" "Wave 1" "Wave 2" "Wave 3" "Wave 4" "'

foreach x of local sheets{
     import excel "/Users/a/Downloads/EVSdata.xlsx", sheet("`x'") 
     save "/Users/a/Downloads/sheet_`x’.dta"
}

The output does not show any error but it does not save the data either.

Bicep · Accepted Answer · 2020-12-04 01:27:45Z

2

A good attempt, but there are a few small syntax errors in your code. Note the subtle differences in this code:

local sheet = `" "Data dictionary" "Wave 1" "Wave 2" "Wave 3" "Wave 4" "'

foreach x in `sheet' {
     import excel "mydata.xlsx", sheet("`x'") clear
     save "sheet_`x'.dta", replace
}

answered Dec 4, 2020 at 1:27

Bicep

1,1035 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Stata loop to retrieve data from Excel file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related