How to merge data in Stata | Combining datasets in Stata

In this video, we explained how to merge data in stata. There are two commands to merge data i.e. append and merge. Append is used when u want to add additional rows to data whereas merge is used when you want to add an additional columns or additional variables data or combine data for different variables in different files. So if you are interest in combining datasets in stata then this video is for you.

Following link contains the files used in the video:

Following link contains more information on this topic:

00:00 Introd to Merging data
2:10 Merge using menu
2:36 Master and Using data

How to combine multiple files in stata

How to combine categorical variables in stata

Basics of loop in stata

Best 10 Introductory Econometrics Books

Introduction to Econometrics by James H. Stock and Mark Watson

Econometrics for Dummies by Roberto Pedace

Mostly Harmless Econometrics: An Empiricist’s Companion by Joshua

Using Econometrics: A Practical Guide by A. H. Studenmund

Disclaimer: Some links are affiliate links that help the channel at no cost to you.

[thedatahall]

Following link contains the files used in the video:

[mehmeteminbayram]

Hi! Thank you for the video, it was extremely helpful!
Most of the other explanations are for single observations matching single observations, you explained it very well for combining single observations with multiple observations, much appreciated.

[shashik]

Thanks for the explanation. Your videos are among the easiest to understand.
In this video though, you could show the browse window after each operation to show how the data eventually takes shape.

[varunmiglani]

I just merged two dataset with key variable householdid being string variable in both the dataset. I had the new variables in my master dataset. i hope this is fine, i was worried as Stata help window mentioned that key variable should not be string

[mohammadshahadathossain]

Please share the data set. I will help us a lot.