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
marginal effectsDear everyone, I have a regression on GDP where I include both inflation, inflation^2 and one lag o…
Generating new ID variable taking into account duplicates across 2 other variablesFirst time poster, so I’m sorry for any errors… I have two ID variables (ID1 and ID2). I want to cr…
Specification of treatment and control group in diff-in-diffDear all, I am doing a difference-in-differences estimation to see the effect of a parental leave re…
Multilevel model with olog?I usally use the command: mixed dep_var || country_var: Problem is that my dependent variable is o…
Need help with Mean for Grouped DataArray Good morning Stata Family, Please I want to create a new variable for the average wage earne…
Subscribe to:
Post Comments (Atom)
0 Response to Importing multiple excel worksheets using a loop
Post a Comment