SAS SQL 1: Essentials

COURSE OUTLINE:

Description

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

Audience

SAS programmers and business analysts

Prerequisites

Have an ability to:

  • Submit SAS programs on your operating system
  • Create and access SAS data sets
  • Use arithmetic, comparison, and logical operators
  • Invoke SAS procedures

Learning Objectives

  • Query and subset data
  • Summarize and present data
  • Combine tables, including complex joins and merges
  • Create and modify table views and indexes
  • Replace multiple DATA and PROC steps with one SQL query

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