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
How do do multilevel multinomial regression for multiply imputed data?Hello Everyone, I'm doing a project on how high school racial segregation may impact racial/ethnic …
egen rowtotal VS. genHi Statalist, Could you please explain it to me why the following commands don't have the same resu…
Calculating global score for an indicatorI'd like to request for some explanation on how to calculate GLOBAL SCORE in Stata. I am not sure if…
Cross-sectional regression for each ind and yearDear All, I need to estimate a model using a cross-sectional regression for each industry and year …
SYS-GMM: Problem of overidentifying restrictionsHello everybody, I want to analyse determinants of corporate leverage in the past twenty years (wit…
Subscribe to:
Post Comments (Atom)
0 Response to Proper way to merge data
Post a Comment