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
Check if coefficient from two different reghdfe regressions is the sameHi all, I am using Stata 15 on Windows. I have data on houses and study the effect of mixed use on…
SUR-like technique for same outcome but multiple predictorsHello, I am running a series of multinomial logistic regressions that use the same outcome variable…
fit a quadratic time trend using rangestatHi all, I have a 30-year unbalanced panel data, with firm and year. I wish to do a 10-year rolling …
Drop rows that are empty in all variablesHi Statalist I have a question about trying to drop those rows that are empty in all the variables …
mcp error "There was a problem executing -margins-."Dear colleagues, my first post here so apologies if I'm doing it wrong. I always use Royston's mcp …
Subscribe to:
Post Comments (Atom)
0 Response to Importing multiple excel worksheets using a loop
Post a Comment