Advanced SAS SQL
Course Length - 1 Day
This course covers more advanced uses of SQL relevant to SAS Programmers who wish to build on their base knowledge. Specifically, the course goes into more depth around the subjects of joins, making queries more efficient and also how to use SQL pass-through.
Public Course price:
£350.00 plus VAT per delegate
View On-Site course prices »
Advanced SAS SQL Public Course Dates
Public SAS Training courses are run from our training centre - The Old School Hall, 11 Wesley Walk, Witney, Oxfordshire, OX28 6ZJ.
SAS Programmers who wish to further their knowledge of SQL Programming within the SAS System.
Ideally the delegate will have attended the Fundamental SAS SQL course or have an equivalent level of competence. We recommend that attendees have three to six months of regular SAS programming experience to gain the most benefit from this course.
- Proc SQL
- Other SQL Statements
SQLA 2 Joins, Subqueries and In-Line Views
- Natural Joins
- Other Joins
- Set Operators
- Complex Queries
- In-line Views
SQLA3 Handling SAS Tables
- Integrity Constraints
- The DICTIONARY Tables and SASHELP Views
SQLA 4 Handling Database Tables
- Sorting Data From External Tables
- The MODIFY Statement in Base SAS
SQLA 5 Other Topics (Optional)
- Efficiency and Timing Performance
- Execution Control, Error Handling and Exit Status
- Proc SQL and the ANSI Standard