SQL Processing with SAS

Duration: 2.0 days
Course fee: $1,320
EPTO units: 2
CEUs: 1.2

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

Students receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.

Share Your Thoughts

Are there additional topics you'd like for this course to address? Would you like for this course to be offered at another training facility? Let us know by adding to our Interest List.

Course fee and EPTO units will differ for on-site training.

This page was created using SAS software.

-	Public
-	On-site training
-	One-to-one Mentoring
-	Courses by Industry Experts
-	Targeted Learning
-	ABM Training
-	TPS Service
-	Find a Course
-	Register now
-	Course list
-	Curriculum paths
-	Locations
-	Special Offers