Advanced SAS + SQL

Prerequisites

Ideally the delegate will have attended the Fundamental SQL course and have three to six months of regular SAS programming experience

Objectives

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.

Topics

Refresher

Proc SQL
Queries
Joins
Other SQL Statements

Handling Database Tables

Pass-Through
Sorting Data From External Tables

Joins, Subqueries and In-Line Views

Natural Joins
Other Joins
Set Operators
Complex Queries
Subqueries
In-line Views