SAS SQL 1: Essentials Course Details:

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

    No classes are currenty scheduled for this course.

    Call (919) 283-1653 to get a class scheduled online or in your area!

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

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.

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

SAS programmers and business analysts

Ready to Jumpstart Your IT Career?