Advanced SAS SQL

Standard Course
£400 +VAT
per delegate
Course duration: 1 Day

SAS Programmers who wish to further their knowledge of SQL Programming within the SAS System. Specifically, the course goes into more depth around the subjects of joins, making queries more efficient and also how to use SQL pass-through.

Who is it for?

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.

What you will learn

  • Proc SQL
  • Queries
  • Joins
  • Other SQL Statements

  • Uniqueness and Cardinality When Joining
  • Natural Joins
  • Other Joins
  • Set Operators
  • Complex Queries
  • Subqueries
  • In-line Views

  • DICTIONARY Tables

  • Pass-Through

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

Advanced SAS SQL Course Dates

Our courses are live instructor-led and can be attended virtually or at our office.

Back to Training

Talk to us about how we can help