Hi everyone,
I have four datasets 2010, 2011, 2012, 2013 -
variables in dataset2010.dta : name, address, bedrooms10, cars10, pool10
variables in dataset2011.dta : name, address, bedrooms11, cars11, pool11
variables in dataset2012.dta : name, address, bedrooms12, cars12, pool12
variables in dataset2013.dta : name, address, bedrooms13, cars13, pool13
bedrooms, cars and pool are numbers. Only some names repeat across all four datasets.
My finaldataset.dta should be : name, address, bedrooms10, cars10, pool10, bedrooms11, cars11, pool11, bedrooms12, cars12, pool12,bedrooms13, cars13, pool13.
What is the command that I should be using?
Thank you.
Related Posts with Match four files on one variable to create new dataset
stata commandI have several observations (individuals) with each belong to a household (so each has a household I…
Odds ratios and Interaction effects InterpretationHi All, I have having some trouble interpreting some interaction effects of some panel data ordinal…
New program -ineqdecgini- (Gini coefficient and its subgroup decomposition) now available on SSC-ineq …
Addtions of observations with conditionsHello everybody, I have a big dataset to manage and I'd like to reduce it. To do so, I want to add …
regression loop !Dear Colleagues I have daily stock returns and market return for 100 firms and for a number of year…
Subscribe to:
Post Comments (Atom)
0 Response to Match four files on one variable to create new dataset
Post a Comment