Stata for Undergraduates 14: Combining Data Sets

  Рет қаралды 62,053

Rochester Econometrics

Rochester Econometrics

Күн бұрын

This video discusses how to combine data sets in Stata.
The Stata for Undergraduates video series is an introduction to working with data in Stata, designed for ECO 231W (undergraduate econometrics) at the University of Rochester. All videos are copyright 2015 by the Department of Economics, University of Rochester.
Commands summary:
2:44: gen test
4:20: help merge
5:23: merge m:1
8:35: append

Пікірлер: 9
@highartalert6927
@highartalert6927 3 жыл бұрын
The intro of this video is so rad! These are my kinda economists!
@andreagama2888
@andreagama2888 4 жыл бұрын
Okay, but this just made me feel like the most accomplished and happiest undergrad, because I finally managed to solve a problem I was having after one week, Thank you so much :')
@bongumusakhoza3863
@bongumusakhoza3863 6 жыл бұрын
Commands summary: 2:44: gen test 4:20: help merge 5:23: merge m:1 8:35: append
@ahmedbadr4561
@ahmedbadr4561 6 жыл бұрын
Thank you so much
@KuldeepSingh-kq9yj
@KuldeepSingh-kq9yj 2 жыл бұрын
i have two files in excel, one the data file and the other is supplementary file consists of names of villages and its code. I want to import data file into stata with names of the villages corresponding to their codes. In the data file only the codes of villages have been mentioned not the name. the solution in the video will work in this situation? can you tell me the way to do that? example: 1 (code) ABC (Village name). 1 20 2 DEF 1 30 2 34 2 35 (the first one is in supplementary excel file, and second one is data file) 1 ABC 20 1ABC 30 2 DEF 34 want to Import data like this in STATA. Which command will work?
@1ivoleuppi
@1ivoleuppi 5 жыл бұрын
i have an urgent question: im trying to make a longitudional file from multiple eurobarometer files. i want to measure the changes in issues mentioned as the most important problem over time. can anyone help me. i know so little about stata i dont even know what to look for
@sabinkstudio
@sabinkstudio 8 жыл бұрын
What if the data is hierarchal and i want the 'using' data to match two variables in the 'master data', 'country' and specific 'year'?
@royros76
@royros76 7 жыл бұрын
then you just write "merge m:1 country year using XXXX
@kierballar4218
@kierballar4218 7 жыл бұрын
thanks!
Using Stata: Merging Data
28:29
Jason Burns
Рет қаралды 3,5 М.
Merging Datasets in Stata
19:43
Michelle Benson
Рет қаралды 22 М.
Bike vs Super Bike Fast Challenge
00:30
Russo
Рет қаралды 23 МЛН
9. Stata One to Many (1:m or m:1) merge
21:12
Learn data analytics with us
Рет қаралды 13 М.
Combining data files in Stata
7:53
Doug McKee
Рет қаралды 47 М.
Stata for Undergraduates 15: Data Types
9:43
Rochester Econometrics
Рет қаралды 7 М.
Combining and Collapsing Data Using STATA
40:03
PolicyFrontiers
Рет қаралды 8 М.
Stata for Undergraduates 2: Basic Workflow
8:56
Rochester Econometrics
Рет қаралды 3 М.
How to Merge (combine) Data in Stata
21:52
The Data Hall
Рет қаралды 3,7 М.
Categorical Variables in Stata
7:56
SebastianWaiEcon
Рет қаралды 137 М.
Introduction to STATA for Statistical Data Analysis tutorial for beginners
46:04
Cleaning Data in Stata
22:42
Alan Neustadtl
Рет қаралды 98 М.
How to merge data in Stata | Combining datasets in Stata
15:21
The Data Hall
Рет қаралды 19 М.