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
-npregress- average derivatives change each time I rerun the model, why?I am running the following nonparametric regression: Code: set seed 12345 npregress kernel spending…
Generating scores using combinations of weighted variables and dividing by the sum of weightsHi all, I would like to create weighted genetic risk scores using a combination of 27 SNPs (variable…
Creating new variable keeping just the first letter of each word in a stringHello all, I have a list of 250+ schools and want to create a variable that takes the first letter …
Putpdf with R2Hi all, I'm trying to save some regression results, and I'm using putpdf: Code: putpdf begin //…
How to calculate mid-year population (i.e., as of 1st July)?Hi All, I am struggling with how to calculate mid-year population (as of 1st July) to calculate crud…
Subscribe to:
Post Comments (Atom)
0 Response to Proper way to merge data
Post a Comment