Stata for Undergraduates 14: Combining Data Sets
HTML-код
- Опубликовано: 11 сен 2024
- 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
The intro of this video is so rad! These are my kinda economists!
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 :')
Commands summary:
2:44: gen test
4:20: help merge
5:23: merge m:1
8:35: append
Thank you so much
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?
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
thanks!
What if the data is hierarchal and i want the 'using' data to match two variables in the 'master data', 'country' and specific 'year'?
then you just write "merge m:1 country year using XXXX