Hi everyone,
I'm still taking my first steps in Stata. Still, I have quite a lot of data (simulated hourly data for three centuries).
As results differ depending on the input variables, I have about 30 different files (named Data_01.xlsx, Data_02.xlsx and so forth).
Each of the files is structured the same way: I always have the same variables (about 20) and about 788.000 observations (I included three runs in one Excel file).
Now I'd realized that I can't simply add data from a second file as it replaces data from the first file.
But of course, the aim is to analyze the whole data at a single blow.
Maybe someone here can help me along?
Thanks a lot and best wishes
Simon
Related Posts with Using data from multiple files (Excel)
no observations when using GMM xtabond2I am trying to use one-step system GMM in stata using xtabond2 but keep getting the error 'no observ…
Limited number of categories with cmmprobitHi, I need to run a multinomial discrete choice model, where I have a wide number of choices (50+) …
Expanding data with start/end date to include all dates in betweenI have a dataset with information on individual id, signup & dropout year/month in the program I…
Reported p-value in Stata when working with population.Hi guys, I have a large dataset of scores provided to movies that I collected through web-scraping.…
Creating, appending and exporting tablesDear all, I have a dataset of people who have lost their employment during the period 2019-2021. I h…
Subscribe to:
Post Comments (Atom)
0 Response to Using data from multiple files (Excel)
Post a Comment