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.

Fundamental SAS SQL

Course Length - 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.

Fundamental SAS SQL Public Course Dates

Due to Covid-19 all Amadeus training will be delivered via live web classes. Our live Web classes are as interactive as our classroom training, there are also some benefits - no travelling time and costs!

Audience

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



Prerequisites

Ideally the delegate will have attended the SAS Fundamentals 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

SQLF 1 lntroduction to Proc SQL

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

SQLF 2 Selecting Data From a Single Table

  • 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)

SQLF 3 Joining Data From Two Tables

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

SQLF 4 Other SQL Statements

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

SQLF 5 Using Macro Variables

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