Hi,
I would like to merge two data sets. Dataset A contains the values of the variable x. Among them are duplicates and missing values. Dataset B contains the variables x and y. In the dataset B the variables x are unique, i.e. no duplicates and missing values. The variable y does contain duplicates, i.e. some unique values of x correspond to the same y value. I have tried "merge m:1 using dataset B", but I ve received the errror message that "the variable x does not uniquely identify observations in the using data", which makes sense. Dropping the duplicates from dataset B is not an option. The task I would like to perform would be quite easy in excel with the vlookup function, however this is not possible due to a high number of observations. Do you have any suggestions?
Thank you very much
Best
Denis
Related Posts with Merge with duplicates in the using data set
String variablesHi STATALIST, I have a string variable and detected ga68 out of it by: Code: gen ga68 = (strpos(…
How to use explicit coding for multiple dummies in regression (no factor notation)Hi. I would like to run a fixed effects regression containing a continuous-categorical interaction w…
Proportion confidence interval with 95% CIHow I can make a two way plot with CI. Like this graph …
Individual fixed effectsDear all, Is it possible to do an individual fixed effects analysis with cross sectional data? If i…
Unbalanced Panel data xtlogit Hi all, I have unbalanced panel data from 2010-2017 of people who participated in a screening prog…
Subscribe to:
Post Comments (Atom)
0 Response to Merge with duplicates in the using data set
Post a Comment