SQL Processing with SAS

Classroom duration: 2.0 days Live Web duration: 4 half-day sessions Please note the System Requirements below. CEUs: 1.2
(This course is not currently scheduled.)

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

Expand/Collapse All Expand All Collapse All Print version

Prerequisites

Before attending this course, 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 I: Essentials course. No knowledge of SQL is necessary.

Course Contents

Introduction

understanding the purpose, design, uses, and terminology of SQL
introducing the case study for the course

Basic Queries

learning the features and functionality of the SQL procedure
specifying columns
specifying rows
summarizing data with column and row functions, grouping data, performing analyses on groups of data, subquerying, and remerging
ordering data
customizing query output

Combining Tables

querying multiple tables using joins
understanding Cartesian products
using union, intersect, and other set operators to combine tables
comparing how the SQL procedure and the DATA step combine tables

Creating and Modifying Tables and Views

creating tables
creating views
using views to simplify queries and access changing data
understanding performance and space issues related to using views
creating indexes
understanding the advantages and disadvantages of using an index
maintaining tables, views, and indexes

Additional SQL Procedure Features

using SQL procedure features for testing programs
using dictionary tables and views
controlling job execution
using the SAS macro facility with the SQL procedure

Software

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

Course Materials

Classroom: Students attend classroom courses in one of our public training centers. You receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.

Live Web: Students attend Live Web classes using a Web browser and a telephone and interact with their instructor and fellow classmates in real time. Each student receives an e-mail with instructions on how to join the class three business days before the class begins. The instructions e-mail includes a link to download the course materials. Students need to download and print the course materials prior to class.

System Requirements

For Live Web, you must

review and follow the general system requirements.
complete the course exercises through our virtual lab. The virtual lab allows you to access the software used in class over the Internet, so that you do not need this software on your local machine.
run this test to connect to a virtual lab session. If firewall problems prevent you from connecting to the virtual lab, then you will need the following software installed and configured in your environment to participate in the course exercises:
- Base SAS 9 or 8.2, on a Windows operating system or SAS Learning Edition
  Important:
  - Students using SAS Learning Edition will need to create a shortcut to the SAS windowing environment (SAS Explorer, Enhanced Editor, Log, and Output windows) for use during the class. Follow these instructions for creating a shortcut to SAS prior to class.
  - If you are using Enterprise Guide rather than writing SAS programs in the Enhanced Editor, this class is not an appropriate offering.

Share Your Thoughts

Not sure if this course suits your needs or which delivery method is right for you? Give us a call at 800-333-7660 or send us e-mail. If you have suggestions for this course or would like for it to be offered at another training facility, let us know by adding to our Interest List.

Available for on-site training or can be scheduled at any SAS training facility

This page was created using SAS software.

Learning Center

Stay in Touch

Not sure what course to take?

Submit Your Course Requests

On-site Pricing