Generating detail reports by working with a single table, joining tables, or using set operators in the SQL procedure.
Generating summary reports by working with a single table, joining tables, or using set operators in the SQL procedure.
Construct sub-queries and in-line views within an SQL procedure step.
Comparing solving a problem using the SQL procedure versus using traditional SAS programming techniques.
Accessing dictionary tables using the SQL procedure.