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
get 1) marginal effects and 2) model fit indices of Tobit models in Structure equation model (SEM) framworkHello all, I am using the two Tobit models in the structural equation model (SEM) framework as belo…
Linear Probability Model InterpretationHi All! I hope you are well. I have been trying to use linear probability models, but I am not so s…
HP filterHello! I am a new user in Stata and I am struggling with this situation. I have panel data. I want…
How to right labels in the vertical lines of a graph?Hello, I´m trying to put vertical labels in a graph. In the line 3158 I would like to write "Beginn…
how to do a bar chart excluding the most frequent one? Hello, I am trying to demonstrate in a bar chart the percentage of people in various ethnic groups.…
Subscribe to:
Post Comments (Atom)
0 Response to Match four files on one variable to create new dataset
Post a Comment