I am struggling to perform a 1:m merge on two merge variables that are both string variables. When I attempt the merge, I get the familiar "variables FirstName LastName do not uniquely identify observations in master data" error. So, of course, I run the duplicates command to find my duplicates and figure out a solution.
The problem is that duplicates flag zero duplicates based on the two merge variables. My hunch is that something is going wrong with how these string variables are being stored. One is of the type str35 and the other is strL - I'm not very familiar with strL types.
Does anyone have an idea of why my merge command is flagging duplicates but the duplicates command is not?
Related Posts with merge vars do not uniquely identify observations in master data - but no duplicates found
graph with range in x axisDear All, Suppose that I have this code Code: sysuse auto, clear twoway (scatter mpg weight if weig…
Dealing with singular covariance matrix in Seemingly Unrelated Regression (sureg)Dear all : Thank you for your help in advance. I’m the user of Stata MP/16.0. I have a panel data…
Unpaired t-test with weightHello, I'm dealing with the descriptive statistics for a data set. Two variables related to paterna…
Reduced sample size in time trends analysisHi, I have an indicator variable EventIndicator, which takes the value 1 if a firm is headquartered …
Fuzzy matching: choosing potential matches (reclink/matchit)Does anyone know how reclink chooses which potential matches to report? Does it effectively sort the…
Subscribe to:
Post Comments (Atom)
0 Response to merge vars do not uniquely identify observations in master data - but no duplicates found
Post a Comment