Advanced SAS + SQL
Prerequisites

Existing programmers in the SAS language who wish to gain best practice programming knowledge. Those who wish to process efficiently within the data step, in addition to configure their SAS environment to maximise data throughput.

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

Other Topics

  • Efficiency and Timing Performanc
  • Execution Control, Error Handling and Exit Status
  • Proc SQL and the ANSI Standard

Handling SAS Tables

  • Indexes
  • Integrity Constraints
  • The DICTIONARY Tables and SASHELP Views
  • Register Online