Stata Tutorial: Intro Data Cleaning with Panel Data

Getting your data ready for analysis in Stata. An example using World Bank country level panel. Topics include: .do files; preserve/restore; renaming; labeling variables; macros and variable lists; missing observations; string variables; balancing a panel; outliers.
www.amazon.com/gp/product/159...
Link to the excellent Introduction to Econometrics Textbook by AH Studenmund:
www.amazon.com/gp/product/933...
Link to Jeffrey Wooldridge Introductory Econometrics Textbook:
www.amazon.com/gp/product/813...

[@TheRachelmyers01]

Thank you so much! I was pulling my hair out, no one made it simple language. Thank you!!!!

[@m.abdurrahmanmehrabi4147]

The whole day I was searching to find the missing data command for Stata. thank you so much.

[@mikejonaseconometrics1886]

Glad it was helpful!

[@JoelDossa-zb4bs]

Thank you so much Mr. Mike, God bless you

[@dominiquewillem]

This is the video I was searching for for the last 3 days, so helpful! Thank you very much!

[@datawithstata]

Great video! Great delivery and insights!

[@Metzgersopium]

You sir just saved my day!

[@martihere7576]

The most helpful video I found! TY

[@junenye]

You're amazing! Love your detailed information

[@mikejonaseconometrics1886]

Thank you-glad it was helpful!

[@AverageEnjoyer888]

You sir literally saved my Bachelor Thesis, thank you so much!

[@mikejonaseconometrics1886]

Glad I could help!

[@journeyq8]

It is very helpful. Many thanks

[@shahifaassajjadiyyah2499]

this is very helpful, thanks a lot!

[@abdulhamittayfur1076]

thank you for this amazing video! very useful!

[@mikejonaseconometrics1886]

Glad you enjoyed it!

[@selcenzorlu]

I get "command _pecats2 is unrecognized" error when using wbopendata, topics(15) long command. ı would much appreciate if you could help me solve this error

[@datawizard-ie6lv]

this is genius

[@sajid2416]

Great stuff.

[@buffalosniper6896]

Thank you sir. This was really helpful :)

[@mikejonaseconometrics1886]

Glad to hear it - Thanks!

[@alexp4385]

cheers for the oc mike jonas

[@artemiocardenas6543]

Thanks. Also, Go Dons!

[@michellezhang6393]

Thank you!!!

[@mikejonaseconometrics1886]

You're welcome!

[@ruwanlasantha5992]

This is really helpful. In your example, if I want to keep countries with at least one observation for y variable for the entire period (i.e 1960-2019) and drop only countries that Y is missing for entire period (1960-2019), how to do that? This is a burning question for my research. It is really appreciated if you could suggest a command. Many thanks

[@akakhbod]

Great ..

[@samuelandre2899]

Thank you for such a great and detail explanation. i'm in the middle of research of panel data and find some trouble in dealing with outliers. How to deal with it? my box plot proved that i have some data outside the upper line of box plot for all of my variable. Is it showing the outliers? and what should i do? is it going to affect my result? (N.b: after doing hausmann and any other test for choosing the best regression model for panel data, the result suggested that i should run a random effect) really wish you could help, thank you :)

[@selcenzorlu]

After searchig and installing _pecats2 command my issue was solved.

[@elnils99]

Thanks for this great video. Can you help me finding the follow-up video? Many thanks!

[@maiqiding2995]

Hi, I know this a rather dumb question but I am genuinely stuck. I tried to type "wbopendata,topics(15) long" and it kept saying command _pecats2 is unrecognized. I tried a dozen times but it still doesn't work. However, the command worked without "long"- wbopendata,topics(15) clear. I indeed don't know where went wrong. TIA! (p.s. I am certain that my STATA and that package is up-to-date)

[@Owiredua_xx]

I am encountering the same problem, did you ever find a solution

[@Mat-mt8pk]

Thank you sir. Please balance the intro/outro volume(It is too loud) with the main content part.