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

This video shows how to merge data in Stata. We will focus on its applications and potential pitfalls. This lecture series is intended for economics, management, and finance application.

[@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