Hello everyone,
I have a single excel file that has multiple worksheets, the worksheets are named Country 1, Country 2, Country 3 etc. I want to be able to import all these worksheets and save each one as a data file using a loop. I'm capable of doing it individually but it makes my code very long. Also, how would I be able to merge all these dta files into one file afterwards?
Thanks for the help!
Related Posts with Importing multiple excel worksheets using a loop
compare variable (gdp) developmentHey, I want to compare the development of log(gdp) of some countries in one graph. But for a better …
Treatment and controlDear all, I have to create a treatment and a control group. For example, I have a variable called "b…
How do I reshape this data automatically?Dear all, I need to "re-shape" some data automatically, but I don't know how to do it. The format …
robust Error TermWhy doesn't Stata provide the information on the total sum of squares, model sum of squares, and res…
Converting numeric date variable to string variableDear all, I am very new to Stata. I want to convert the numeric date variable "cdint" (type: long, f…
Subscribe to:
Post Comments (Atom)
0 Response to Importing multiple excel worksheets using a loop
Post a Comment