Stata - How to merge datasets

preview_player
Показать описание
Welcome to my classroom!
This video is part of my Stata series. A series where I help you learn how to use Stata. In this video, we look at how to merge two datasets using the merge command in Stata. We look at one-to-one and one-to-many merging.

Note: What I show here is my take on the topic. I would be happy to receive comments!

Useful links:
  1. Steffen's Classroom
  2. Stata
  3. Introduction
  4. Intro tour
  5. tour
  6. how to
Рекомендации по теме
Merge two datasets 0:09:42

Merge two datasets by adding new variables in STATA | Road to PhD

Data management: How 0:05:24

Data management: How to merge files into a single dataset

Stata Lecture 16: 0:09:10

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

Stata - How 0:12:17

Stata - How to merge datasets

9. Stata One 0:21:12

9. Stata One to Many (1:m or m:1) merge

Take Less Than 0:00:48

Take Less Than 1 Minute to Master M:1 Stata Merging

Stata Tutorial: Merging 0:06:27

Stata Tutorial: Merging Two Data Sets

Stata for Beginners 0:14:44

Stata for Beginners - Merging Data files

How to Merge 0:21:52

How to Merge (combine) Data in Stata

Stata 36 - 0:06:07

Stata 36 - Merge two data sets

Tutorial Merge (Combine) 0:10:00

Tutorial Merge (Combine) Multiple Files In Stata

90 Seconds to 0:01:35

90 Seconds to Master 1:1 Merging in Stata

How to merge 0:15:21

How to merge data in Stata | Combining datasets in Stata

How to Combine 0:11:35

How to Combine Multiple Files in Stata | Stata Tutorial

Using Stata: Merging 0:28:29

Using Stata: Merging Data

Stata: Datensätze zusammenführen 0:03:30

Stata: Datensätze zusammenführen mit dem merge-Befehl

Understand Stata Merging 0:01:13

Understand Stata Merging 1:M in 1 Minute

Merging Datasets in 0:19:43

Merging Datasets in Stata

Stata - How 0:06:58

Stata - How to append datasets

Data Analysis using 0:11:27

Data Analysis using Stata, MERGE DATASETS, one-to-one, one-to-many and many-to-one, Ep 6 #merge

7. How to 0:06:18

7. How to Merge Two Datasets in Stata? #datamanagement in Stata #Statistics #Datascience

Merge and append 0:05:24

Merge and append data in stata

Stata: A Simple 0:10:27

Stata: A Simple Merge of Data in Stata

Merging more than 0:20:58

Merging more than two datasets in Stata (using single command)

Комментарии
Автор

Thanks from France ! it has been useful !

loancet
Автор

Thanks it's helpful, we hope you would show us how tu use our single data from excel or from data stored out of stata for example... because this is the most used type I guess ! Thanks again (y)

frikhatomar
Автор

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?

alihussien
Автор

Hi Steffen, thanks a lot. I have a doubt. I have two datasets, one contains individual-level obs (var is idno) and the other has political parties as obs (string var is party). Both parties and individuals are nested in countries. The only var in common is indeed country, yet does not uniquely identify the obs. I would like to merge the two, by generating multiple obs for each idno in the master dataset corresponding to each idno-party pair in the same country. Unfortunately I'm stuck. Shall I create another variable to merge the two? Thanks a lot

NathanCats
Автор

Stata automatically copy the original observation data when we do the 1:many. How make to NOT copy? Or, how to treat this additional observation (added after merging) as missing data?

proguifreccia