Hello I have two data sets, they both have the common variable person_ID. One dataset consists of the date on which people where arrested before a treatment effect, the second data set consists of the dates people where arrest after a treatment effect was given. I want to merge these data sets. The problem I run into is the way the variable person_ID was coded.For example there is a person in this data set that was arrested at three distinct dates, he is given the ID 1, so this person appears as 1 three times in the data set. In the second dataset this individual was arrested twice so in the merged data set 1 should appear 5 times. When I try the command merge is fails to merge in any of the possible combinations. If this was unclear please tell me and I will clarify.
Related Posts with Proper way to merge data
Add mean, sd and median names to table outputHi all I wonder if its possible add mean, sd and median names to a table output , example: Code: …
Two way fixed effects and interaction termsHello Stataforum, I'm working on a generalized difference difference model with multiple groups and…
Test for significance of Time DummiesHi, I am doing a FE and RE Regression and I am not sure if I should use Time Dummies (i.date) or a …
Type missmatch, dropping string observations from a VariableHello, Starting a new thread since I finally need something different from what I had before. How…
Is there any difference between "Sort X Y" versus. "Bysort X Y: gen A=1"I know in Bysort you have to generate something. But other than that will using Sort X Y vs. Bysort …
Subscribe to:
Post Comments (Atom)
0 Response to Proper way to merge data
Post a Comment