Hi,
I have to merge about 40 datasets using a key ID. The "hhid" variable present in all datasets, but I keep seeing "variable hhid does not uniquely identify observations in the using data". I converted the hhid to numeric in all the datasets and tried all three types of merge (1:m/m:1/1:1) but still no luck. Can someone guess what can be the issue here?
Here is the command:


Code:
foreach file of local myfiles {

   merge 1:1 hid using  "`file'", nogenerate force

   }
Thank you!