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
LoopDear All, I have a variable, say country, which contains the name of countries in my dataset and I …
Generate new variable in panel data on the condition that another variable is contained within a list.New to this forum, so sorry for the wordy title. I have 9 waves of individual level panel data on d…
Conflicting stationarity test results, how to proceed?Hi there, I have time series data on a number of variables and am hoping to do VAR and VECM analysis…
specification error in panel dataHello, I am running a panel regression (xtreg) on an unbalanced dataset with large N, small T. I wa…
Graph formatting for Forrest plotsI have generated a meta-analysis forrest plot using metaprop by subgroup (ie presented 2 subanalyses…
Subscribe to:
Post Comments (Atom)
0 Response to Proper way to merge data
Post a Comment