Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-800-268-7737 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


SAS SQL 1: Essentials

GK# 2422


Course Overview


This course teaches you how to process SAS data using Structured Query Language (SQL).


  • Delivery Format:
  • Date:
  • Location:
  • Access Period:



Viewing outline for:

Classroom Live Outline

1. Introduction

  • Overview of SAS Foundation
  • Course logistics
  • Course data files
  • Introducing the SQL

2. Basic Queries

  • Overview of the SQL procedure
  • Specifying columns
  • Specifying rows

3. Displaying Query Results

  • Presenting data
  • Summarizing data

4. SQL Joins

  • Introduction to SQL joins
  • Inner joins
  • Outer joins
  • Complex SQL joins

5. Subqueries

  • Noncorrelated subqueries
  • In-line views

6. Set Operators

  • Introduction to set operators
  • The UNION operator
  • The OUTER UNION operator
  • The EXCEPT operator
  • The INTERSECT operator

7. Creating Tables and Views

  • Creating tables with the SQL procedure
  • Creating views with the SQL procedure

8. Advanced PROC SQL Features

  • Dictionary tables and views
  • Using SQL procedure options
  • Interfacing PROC SQL with the macro language

9. Learning More

  • SAS resources beyond this course


Viewing labs for:

Classroom Live Labs

Exercises or hands-on workshops are included with most SAS courses.

Who Should Attend


SAS programmers and business analysts

Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 2 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 5 day

Request this course in a different delivery format.