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)
Quarterly population data into monthly dataDear Statalist experts, I have the following data set, I have been trying to transform this quarterl…
FGLS test to solve only Heteroskedasticity problem in Fixed Effect ModelHello, My dependent variable is NPLs (Non-performing Loans) and 6 independent variables - M3 = Money…
Percentage increase in estimated probabilities for binary treatment and binary outcomesI have a binary outcome variable and a binary treatment variable. Using margins, it's easy enough to…
Help in reshapingHi I have a dataset of industrial clusters which are segmented into districts, states and products (…
Drop Observations which are contained more than once in Panel DataDear Stata Community, I have the following dataset: Household_ID Personal_ID Round 1 1 1 1 2 1 1 2…
Subscribe to:
Post Comments (Atom)
0 Response to Using data from multiple files (Excel)
Post a Comment