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
import many csv filesDear All, I generate many csv and excel files as
Code:
cd "E:\Stata\import data\manycsv"
webuse g…
Graph bar with custom labelsDear Statalist
I have been struggling with the following issue for quite a while now. Unfortunately…
SOEP weightingHi,
I am new to STATA and have a project where I use SOEP data. I would like to calculate a weighted…
Data manipulation for ciplotI use -ciplot- to show the state of Health (1Very Good...5Very bad) across Age. -ciplot- graphs the …
reshape or what?Dear All, I have this dataset,
Code:
* Example generated by -dataex-. To install: ssc install data…
Subscribe to:
Post Comments (Atom)
0 Response to Proper way to merge data
Post a Comment