If you already know the basics of Stata, or watched our Stata Fundamentals video , you are ready for more advanced Stata! This video will cover advanced Stata functionality through eight clips:

Creating Loops in Stata. This first clip in this video series will explain how to create loops in Stata. Master the foreach statement and then export your statistical results to Microsoft Excel.
Leveraging Local in Stata. This second clip in the Stata video series covers how to use Local, which can be very handy when creating loops in Stata. Local is an object that you can create in Stata to support your code.
Appending Data in Stata. This third clip in the Stata video series covers how to master the append command in Stata.
Merging Simple Data Sets in Stata. This fourth clip in the Stata video series covers how to master the merge command in Stata.
Merging Complex Data Sets in Stata. This fifth clip in the Stata video series covers more complex merging, including the one-to-many merge.
Applying Additional Merge Options in Stata. This sixth clip in the Stata video series covers options available in merge that handle more specific situations, such as merging data sets with common variables, and merging when faced with missing values.
Reshaping Data in Stata. This seventh clip in the Stata video series explains how to master the reshape function in Stata. Learn about wide and long data formats, and how to transform wide tables to long tables for better statistical analysis.
Validating Data in Stata. This eighth clip in the Stata video series explains how to validate data in Stata. Although we will use a survey as an example, you can use the techniques for any data entry project. Learn a number of Stata commands including assert, inlist, inrange, and duplicates.
Regression in Stata. This ninth clip in the Stata video series explains how to do regression analysis in Stata. Analysis is performed with continuous and independent variables using the regress command.