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
Marginal effect in an Ordered probit model with discrete variablesDear Statalist Team, I have an ordered probit regression, where the outcome variable contains 4 pos…
random intercept random slope in multilevel GSEMHi, i would like to ask about adding random slope into the mediation model using GSEM. My model look…
st_store() and stata() when using moptimize(): IV qregHi, I have a Mata function that creates a column vector (called yd below), passes it to Stata as a t…
🐍 Python: write to text fileDear All, below is a Stata-Python interface question. I need to write to a file opened in Stata fr…
_= invalid name r(198)Hi, I'm just getting back into Stata after a long illness, so I could use some help. I'm trying to r…
Subscribe to:
Post Comments (Atom)
0 Response to Combining datasets
Post a Comment