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
Deleting rows with NAsDear Statalists, I would like to delete rows where are only 7 real values and the rest is NA, does a…
mata function available in different ado-filesDear all, I am trying to execute a mata function in different but related ado-files, but I don't kn…
Command to list households with multiple heads/without heads in a survey dataBelow is a extract data from a survey conducted for various households within a community, please wh…
-gsem- for dynamic multinomial logit model with random effectsDear All, I am trying to analyse, using panel data, the extent of state dependance to a previous si…
Calculating citation half-lifeDear all, Assume that you have the following problem. You have patent citations for firms in differ…
Subscribe to:
Post Comments (Atom)
0 Response to Match four files on one variable to create new dataset
Post a Comment