Topic: How to combine multiple files in stata
Combine CSV, excel or stata data (.dta) files into single file. If we want to combine data from multiple csv files then we will have to first convert them into stata data format and then we will combine data into a single file.
Following link contains the files used in the video:
https://payhip.com/b/hEt18
Following link contains more information on this topic:
https://thedatahall.com/how-to-combine-multiple-csv-excel-files-in-stata/
0:00 Intro to video
0:50 Step 1: Set the Currenty Directory
1:21 Step 2: Convert excel/csv files into .dta file
5:12 Step 3: Append data into 1 file
How to use foreach loop in stata:
https://www.youtube.com/watch?v=jFs_F1FyQy8&t=8s
How to use forvalues loop in stata:
https://www.youtube.com/watch?v=Zoy9crKwnAU&t=34s
Basics of loop in stata:
https://www.youtube.com/watch?v=9pp3Sn1N-DM&t=15s
Best 10 Introductory Econometrics Books
https://thedatahall.com/best-10-introductory-econometrics-books/
Econometric Analysis of Cross Section and Panel Data by Jeffrey M. Wooldridge
https://amzn.to/4220RUA
Introductory Econometrics for Finance by Chris Brooks
https://amzn.to/3HwmOmM
An Introduction to Modern Econometrics Using Stata by Christopher F. Baum
https://amzn.to/42prKBT
Microeconometrics Using Stata by A. Colin Cameron and Pravin K. Trivedi
https://amzn.to/42ra88r
Website: thedatahall.com
Disclaimer: Some links are affiliate links that help the channel at no cost to you.