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 Outreg2 with multiple regressions nested in a foreach loopI am running a couple of regressions that I have nested in a `foreach' loop but I want the regressio…
Lagged time dummies, panel regressionHello all, I am trying to estimate a panel regression measuring the effect of different events on d…
splitting stringDear all, I am wondering how to split data from a long string on the comma (like for example: Colru…
Random sample by unique observationsHello Statlists, I'm currently struggling with my dataset. I have a large dataset of around 7 000 0…
Joint coefficientsDear Statalist users, This is my first post here and sorry in advance if the post does not fully com…
Subscribe to:
Post Comments (Atom)
0 Response to Proper way to merge data
Post a Comment