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
Imputation methodHello, dear Stata community, I have questions related to imputation and winsorization methods that …
Not achieving convergence in Latent Class AnalysisHi all, I'm exploring an LCA model with a household survey we've ran. This is looking at the activi…
Select one observation within group with complex criteriaHello, I have to select only one document per each firmid (sometimes I have one document per firm id…
Calculating averages (industry+year) based on sub sample and then applying them to all firmsHi, I am still quite new to Stata (using Stata 16) and hope to find help here as I do not know how t…
How does David Dorn endorse a m:m merge?Hi everyone, First time poster to this message board. I had a question about David Dorn's commuting…
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