Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

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

    $

SAS SQL 1: Essentials

GK# 2422

JUMP TO:

Course Overview

TOP

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

Schedule

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

$

Outline

TOP
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

Labs

TOP
Viewing labs for:

Classroom Live Labs

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

Who Should Attend

TOP

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.
Enroll