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
Due to Covid-19 all Amadeus training will be delivered via live web classes. Our live Web classes are as interactive as our classroom training, there are also some benefits - no travelling time and costs!
Audience
SAS Programmers who wish to further their knowledge of SQL Programming within the SAS System.
Prerequisites
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.
Topics
SQLA1 Refresher
- Proc SQL
- Queries
- Joins
- Other SQL Statements
SQLA 2 Joins, Subqueries and In-Line Views
- Uniqueness and Cardinality When Joining
- Natural Joins
- Other Joins
- Set Operators
- Complex Queries
- Subqueries
- In-line Views
SQLA3 Dictionary Tables
- DICTIONARY Tables
SQLA 4 Handling Database Tables
- Pass-Through
SQLA 5 Other Topics (Optional)
- Efficiency and Timing Performance
- Execution Control, Error Handling and Exit Status
- Proc SQL and the ANSI Standard