Amadeus cookies policy - you'll see this message only once.

Amadeus use cookies on this website. They help us to know a little bit about you and how you use our website, which improves the browsing experience and marketing - both for you and for others. They are stored locally on your computer or mobile device. To accept cookies, continue browsing as normal. Or, go to the privacy policy for more information.

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.

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

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

SQLA3 Handling SAS Tables

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

SQLA 4 Handling Database Tables

  • Pass-Through
  • 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