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
Geodist datasets into a panelDear all, I have 3 sets of data - the first is 565,000 gridpoint observations of rainfall, with lat…
Panel data set with spaced time periodsHello Statalist, I am currently analyzing a panel data set of 45 firms across 3 years. However, the…
Matching variables from two columnsHi, everyone! I have two columns with dummy variables, each '0' and '1'. And I want to merge these …
create a dummy pair of countriesHi, how can I create a dummy variable for each Partner if my observations are pairs of countries li…
Network meta-analysisHello. I have the following data set. I get the 'variables study_id treatment do not uniquely identi…
Subscribe to:
Post Comments (Atom)
0 Response to Proper way to merge data
Post a Comment