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
Using inlist when with multiple & and or ( | ) statements to create dummies within a loopHello, In trying to clean up my code, I've run into a roadblock. I'm trying to create a dummy variab…
working with multi‐episode event history datasetAnyone with some experience working with multi‐episode event history dataset ? …
Stacked bar: blabel using a different variableI am trying to create a stacked bar plot: Code: graph bar x1 x2, over(group) Command - Code: blabe…
Oaxaca and Blinder DécompositionHello to all I am trying to implement an Oaxaca blinder decomposition to try to explain the differen…
Centering variablesHello, I have 16 countries across 30+years. My variables are slightly multi collinear as I have GDP…
Subscribe to:
Post Comments (Atom)
0 Response to Proper way to merge data
Post a Comment