SAS SQL 1: Essentials

SAS programmers and business analysts

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
2 day

Description

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

Objective

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

SUBSCRIPTION COST


$1,300.00

Select Course Options

 

NEED HELP OR NOT SURE?