Fundamental SAS SQL

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

This course covers Proc SQL in detail, concentrating on the use of SQL for existing SAS Programmers. Traditional SAS DATA steps and Proc steps are compared with using Proc SQL and efficiency issues are discussed.

Who is it for?

SAS Programmers who wish to know the benefits and role of SQL Programming within the SAS System.

Prerequisites

What you will learn

  • Introduction to Proc SQL
  • Concepts
  • Features of Proc SQL
  • Course Overview

  • Clauses in the Select Statement
  • Simple Examples
  • SELECT Clause
  • FROM Clause
  • WHERE Clause
  • ORDER BY Clause
  • GROUP BY Clause
  • HAVING Clause
  • SAS Data Set Options
  • Other Topics
  • Further Examples (Optional)

  • The FROM Clause Revisited
  • Join Schematics
  • Inner Joins
  • Outer Joins
  • Equivalent DATA Steps

  • Creating Tables
  • SQL Views
  • Changing Data in Tables
  • Changing the Structure of Tables
  • RESET Statement

  • What are Macro Variables?
  • Selecting INTO
  • Lists Using SEPARATED BY
  • Automatic Macro Variables Set by Proc SQL

Fundamental 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