Students who take this course will acquire a deeper understanding of the SAS System and especially the SQL procedure. This understanding will help the student to write more efficient programs as well as utilize more features of the SQL procedure. In some cases, this translates to writing more concise programs.
There are no prerequisites for this course.
This course is intended for two groups of students: those who are brand new to the SAS System, and those who have been using the SAS System for a few years, but want to learn about programming with the SQL procedure.
- Introduction to PROC SQL
- Retrieving Data from ONE Table
- Retrieving Data from SEVERAL Tables
- Examining Real World Applications