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)
Interpolate to end of month instead of mid month data?Hello, all my data are for the end of month. But I have one variable where the data is listed mid mo…
Hurdel model with interval dataHi Does anyone know how to run a hurdle model with interval data? We have asked the respondents abo…
LinktestHey guys, I have a question about the output of the linktest. I know that a significant _hatsq in c…
Dealing with date and timeHi, I am using Stata 16 and seem to have problem extracting year, month and day from a date-time co…
strtrim not producing desired resultsHi Stata Users, I am using strtrim command in Stata 15. The goal is to remove blank spaces at the b…
Subscribe to:
Post Comments (Atom)
0 Response to Using data from multiple files (Excel)
Post a Comment