Stata Lecture 16: How to Merge datasets and what can go wrong?

[@anchal.ak22]

Sir i am working on NSSO 61st round and i am having a problem while merging. Actually, for round 4 to 9, there is no unique id variable without which i am unable to merge it. Please suggest me what can i do

[@alihussien7935]

Thanks for your videos.
I have a problem with merge I won't to merge 1:1 sam key variable . At all I have 7 dataset I like to merge. I get error says variable _merge already defined stata. How can we solve that problem?

[@niachinkhokwe2553]

drop the merge variable....on variables scroll down, rightclick the ''merge'' variable and click on drop the selected variable

[@alihussien7935]

@@niachinkhokwe2553 okay thanks for your help

[@Kroft-Tutorials]

drop the _merge variable.
A less safe way to prevent this is to type nogenerate after the keepusing part of the merge to prevent making the _merge dummy. However, this dummy can tell you how good the coverage of the merge is, do be careful with this option.

[@onyekaenwesi7216]

​@@niachinkhokwe2553 you are right, thank you

[@Musicgoods_]

Thank you