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
Help in unbalanced Panel dataI am using the data from 2003-2017. I have some missing values in my corporate governance and contro…
estimation sample variesGood day, I get following error message Code: bys id: gen treatment=0 if (expectation==2 & f.…
custom maximum likelihood estimators - best way to check for convergence?I've made a package to estimate a model by maximum likelihood. I'd like to store a result as e(conve…
How to test if the mean of a sample is significantly different from zeroHi everyone, I have a sample of 166 bonds (i.e. n=166). I have broken these down into subsamples ba…
Pairwise matching: first nearest neighbourHi, I'm new on Stata and I have some difficulties to realise a pairwise matching. Here is a simplifi…
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