PROC SQL COURSE (PART 1)
Description
SASCrunch Proc SQL course (part 2) is an advanced SAS programming course focusing on the SQL procedure in SAS.
It covers the different types of joins and SET operators using Proc SQL. You will also learn how to update and modify SAS tables and create integrity constraints using the SQL procedure.
Upon completion of the course, you will be capable of performing complex data manipulations and analysis using one of the most powerful and commonly used procedures in SAS.
Highlights
- Interactive training
- 17 training sections
- 27+ exercises
- 7-day money back guarantee
Course Outline
- Introduction
- Cartesian Product
- Inner Joins
- Table Alias
- Inner Join with Summary Function
- Outer Join
- Left Outer Join
- Combine Table Vertically
- Overlaying Columns
- Outer Union Set Operator
- Creating SAS Tables
- Creating SAS Tables using Query
- Inserting Rows into Table
- Updating Tables
- Altering Columns
- Deleting Rows and Tables
- Integrity Constraint
- Final Test
- Coding Exercises
- Coding Exercises (Answers)