Dear
My dataset is split across two large files. the master file has 10,000 respondents all uniquely identified with a unique id. However, in the second file has only 9800 respondents as 200 decided not to participate. I need to merge some variables from the second file into the master file but I am not able to do it as the number of observation don't match across the two files. I have tried using 1:1 merge function but this given an error.
variable unique_identifier does not uniquely identify observations in the using data
r(459);
Can anyone help please?
Related Posts with Merging data using unique identifier
Sorting a variable by two dummy variablesI am working on a paper about discrimination in the labour market. I have three variables (among man…
Basic question on how to draw a vertical line that splits the distribution in a histogramHi all I am stuck in a basic procedure with histograms and hope someone can help. I used the follow…
Measurement error when a variable is in bucketsHello, I've got a variable, AGE, which in my data set is given in buckets. Meaning someone with AGE…
2SLS with linear time trend.Hi all, I am estimating the following model using fixed effects including linear time trends. Cod…
how to export results from a regression to excel, using STATA 13Hi, Could someone help me with exporting me regression table to Excel. I have tried "copy table" an…
Subscribe to:
Post Comments (Atom)
0 Response to Merging data using unique identifier
Post a Comment