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
Multivariate repeated measures mixed effects regressionHello, I have a dataset with cognitive ability score measured at two time points. I am interested in…
Difficulty generating a conditional variableI'm working with some data on NFL football players. I want to generate a variable that reflects how …
Sample selection bias in independent variablesHello Statalist I am doing some work on the effect of formal/informal finance on firm performance su…
Is "reshape long" limited by the number of "i"s: too many variables specifiedHi everyone, I am trying to run a reshape long command with 10 variables specified as i (below comma…
ppmlhdfe Pseudo R2Hi, I am using the regressor: ppmlhdfe It shows me the Pseudo R2. How could I calculate the R2? T…
Subscribe to:
Post Comments (Atom)
0 Response to Importing multiple excel worksheets using a loop
Post a Comment