วีดีโอ

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?

thanks, very helpful

The intro of this video is so rad! These are my kinda economists!

Sir, I have a dataset in stata which has a string variable having names i want to list only those names which starts or contains a particular characters. Please help me out with the command My question in brief sir .. for example I have a dataset with two variables one string variable and another numeric variable i.e., name and age, if i want to list people who are under age of 10 , the command is like list if age < 10 simply stata list out the data, but i want to list out the only people who's names are starting with "S" or a part of name with "ra".. Usually in mysql we write this command select * from xxxx where name like "S%" or name like "%ran%" Which is very simple... but i couldn't get it stata.. Please help me out.. Thank You Sir

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 :')

First of all, thank you for the helpful videos. It really helped me to get into Stata. I hoped you would talk in this video about the issue i have but if you don't mind i ask nevertheless. If i import data from an csv file, there is an dummy variable with observations like 0 and 1. Perhaps this could be the problem, because i if browse the data, Stata does not display the variable in blue but in black. If i import the data, Stata tells me: Note: 566’449 binary zeros were ignored in the source file. The first instance occurred on line 7. Binary zeros are not valid in text data. Inspect your data carefully. I don't really get any help on google or the Stata help..

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

Thank you so much for posting these! I am a student getting started on a research project and have zero previous experience with STATA and these videos have been very useful. The videos move at a good pace and the information has been very very helpful.

were your master and using data sets already loaded into STATA?

Commands summary: 2:44: gen test 4:20: help merge 5:23: merge m:1 8:35: append

Commands summary: 0:45: scatter 1:13: reg 1:55: test 5:08: help density functions 6:00: dis normal (displays the cumulative of a normal distribution function) 6:33: dis invnormal (inverse normal) 7:15: gen runiform (random uniform)

Commands summary: 0:51: “corr” (correlation) 2:08: “reg” (regression) 3:40: robust 4:52: “xi” (Dummy Variables) 6:57: “areg” “absorb”

Commands summary: 0:50: describe “d” 1:45: browse 2:42: sum 3:12: tab 4:24: tabstat

Commands summary: 0:32: display (it also displays values of whatever text is inside quotations) 2:40: count 3:45: list

Commands summary: 0:40: help twoway 1:26: twoway lfit 2:00: twoway (lfit) (scatter) 2:47: twoway qfit 3:18: graph editor 4:40: kdensity 5:50: lpoly

Commands summary: 0:30: help summarize (to observe stored variables) 1:23: display r(“ “) (displays stores variables) 2:12: gen (generate new variables using stored variables) 2:27: browse 4:55: display _b[ ] (displays coefficient of regressor variables in a regression) 5:26: browse _se[ ] (displays standard errors of variable regressor variables in a regression) 6:04: predict

Commands summary: 1:12: “gen” (Generate new variable) 3:02: “replace” “if” 5:40: label 7:13: rename 7:35: edit 9:30: drop 10:03: keep 11:10: save

Commands summary: 1:20: browse 3:15: missing observations 5:20: “hist” (Histogram) 5:58: “bin” (Editing Histogram) 6:58: name 7:25: “scatter” (Scatter plot)

Commands summary: 0:50: describe “d” 1:45: browse 2:42: sum 3:12: tab 4:24: tabstat

Commands summary: 0:38: log 1:35: “cmdlog” (Command Log) 3:10: Inserting Comments 4:08: doedit 4:48: “clear” (within do file)

Commands summary: 0:50: Different manners of getting help 1:41: search 2:17: help 5:59: sysuse 6:50: summarize “sum” 7:12: “sum x1 x2” 7:41: detail “d”

Commands summary: 0:50: “cd” (Change Directory) 2:38: cd 3:17: Explanation of .dta format 3:28: Use 5:18: summarize 6:00: set more off 6:57: cd 7:30: Save Dataset 8:14: replace Dataset 8:23: clear

thanks!

Hi, I want to know why the ANOVA table disappear when you use the robust command ? Thank you

What if the data is hierarchal and i want the 'using' data to match two variables in the 'master data', 'country' and specific 'year'?

Many thanks for your Video! I just have one question: I am testing whether migration increased in the european union when new members joined the EU in 2004, therefore I looking at the difference in migration between countries of the EU and countries outside the EU. Thus I would like to have a graphs with one line representing migration flows in EU countries and one line representing migration flows of Non-EU countries. And It would be great if I could see the two lines diverge from each other in 2004. How could I do that? Best regards, John

Sofa

Saved my great time!