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)
Pre and post policy countHI, So I have panel data for 5 years (4,5,6,7,8) and I am evaluating a policy change that happened …
How do I graph a parameter t distributionDear Statalisters, I have a regression coefficient x2=.2227885 with a SE=.056563 and a 95% Conf. In…
create a table with mean sd and t-test ==0I would like to create a table with the variables as columns and the mean, the standard deviation an…
weird characters of ChineseI have used the following codes to translate the Chiense characters in my dataset (attached). But it…
Replace missing values with closest non-missing value in a panel dataHi, I have a panel dataset (example attached) which is tsset id year. employed is a binary variable…
Subscribe to:
Post Comments (Atom)
0 Response to Using data from multiple files (Excel)
Post a Comment