I have datasets for 12 countries containing a multitude of variables e.g. age, sex, tobacco use, alcohol use, diabetes, and HBP. The issue is that certain variables are missing for some countries, which means I have to clean the datasets one by one to keep the necessary variables to be finally able to append them. So I am wondering if there is and special command for appending that will only retain the variables (for each of the subsequent append) that match those on the master dataset, lets say for keeping only Age, sex and HBP.
Thanks in advance for your insights!
Related Posts with Appending several datasets for selected variables in the master dataset
Premature DeindustrializationHello everyone, I'm testing premature deindustrialization as Rodrik (2015) I regress manufacture em…
xtline and standard deviationHello everyone, I need to draw a lineplot for paneldata. I used the following command: collapse (m…
Help with outputting Mixed command results to ExcelHello, I hope you could help me, I have spent days trying to figure this out. I am trying to output…
Merging two files on multiple criteria and imperfect matching?Hi, I have two data files I want to merge. The issue is I don't have an ID column shared by both fil…
Xtqreg-qunaitle regression in a panel dataDear Joao Santos Silva I am trying to run fixed effects quantile regression for a panel of 260 firm…
Subscribe to:
Post Comments (Atom)
0 Response to Appending several datasets for selected variables in the master dataset
Post a Comment