Training

SAS SQL 1: Essentials - eCourse

Format Duration Requirements Demo Purchase
e-Learning: 24 hours/1-yr license System Requirements View Demo Buy

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

This course can help prepare you for the following certification exam(s): SAS Advanced Programming Exam for SAS 9.

Learn how to

  • 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

Who should attend

SAS programmers and business analysts  

Prerequisites

Before attending this class, you should be able to

  • submit SAS programs on your operating system
  • create and access SAS data sets
  • use arithmetic, comparison, and logical operators
  • invoke SAS procedures.
You can gain this experience from the SAS Programming 1: Essentials course. No knowledge of SQL is necessary.

This course addresses Base SAS software. This course is appropriate for students who are using SAS 8 or SAS 9 software.

Course Outline

Getting Started

  • course logistics
  • introducing the Structured Query Language
  • introducing the business scenario
Basic Queries
  • overview of the SQL procedure
  • specifying columns
  • specifying rows
Displaying Query Results
  • presenting data
  • summarizing data
Subqueries
  • noncorrelated subqueries
  • correlated subqueries (self-study)
SQL Joins
  • introduction to SQL joins
  • complex SQL joins
Set Operators
  • introduction to set operators
  • the EXCEPT operator
  • the INTERSECT operator
  • the UNION operator
  • the OUTER UNION operator
Creating Tables and Views
  • creating views with the SQL procedure
  • creating tables with the SQL procedure (self-study)
  • integrity constraints (self-study)
Additional SQL Procedure Features
  • setting SQL procedure options
  • dictionary tables and views
  • interfacing PROC SQL with the macro language
  • program testing and performance
Managing Tables
  • introduction to indexes
  • creating indexes (self-study)
  • maintaining tables
Accessing Relational Databases (Self-Study)
  • LIBNAME access to DBMS data
  • executing DBMS-specific SQL using the SQL Pass-Through Facility
Learning More
  • SAS resources
  • beyond this course