Dear statalist members,
For my assignment I use 4 datasets. In this 4 datasets I have a variable: Full_Name (string variable) and id (numerical). I need to make a dummy variable Male = 1 if the person is a male and Male=0 if the person is a female. The idea is that I hand collect this information.
Most of the names in the 4 datasets will overlap. That is why I have combined them into one dataset with the command append. I want to remove duplicates by id so I see the name only once. A person's name (so also id) can occur multiple times in the 4 datasets.
Now I am wondering when I want to add this information to my 4 datasets again how do I do that? I think that I will probably have to use the merge function. But do I then have to do 1:m? Or maybe I should use a different command than merge?
I hope I have formulated my question clearly. Feel free to let me know that I did not.
KInd regards,
Sarah
Related Posts with Combining datasets
How can I use the marginal effects after fixed effects and random effects models?Dear Statalist, I use linear model for panel data How can I use the marginal effects after these …
Problem with parallelHello to all, I am not very strong in STATA but I wrote a program. I wanted to parallelize a loop. B…
Wald or F-testI am using GSEM with the svy option (for weights). I am running these models on two separate subsamp…
Collect recode problemHi I am working with the new table and collect command in STATA 17. After I recode levels of a dimen…
Creating N subpopulations by random sampling without replacementDear all, I would like to ask you, wheter it is possible in Stata to create N subpopulations via sim…
Subscribe to:
Post Comments (Atom)
0 Response to Combining datasets
Post a Comment