SAS SQL

Selected option:: Public
Other options:: On-Site
Cost per delegate:: £310.00
Duration:: 1 Day

Audience

SAS Programmers who wish to know the benefits and role of SQL Programming within the SAS System.

Prerequisites

To take this course, you should have taken the SAS Fundamentals course and have some experience of SAS programming.

Objectives

This course covers Proc SQL in detail, concentrating on the use of SQL for existing SAS Programmers. Traditional SAS Data steps and Proc steps are compared with using Proc SQL and efficiency issues are discussed.

Topics

Q1 lntroduction to Proc SQL

Introduction to Proc SQL
Concepts
The SAS Data Model
Workshop Session

Q3 Combining Data

Inner Joins
Outer Joins
Other Joins
Subqueries
Set Operations
Workshop Session

Q2 Selecting Data

The Select Statement
Controls and Enhancements
Analysis on Groups
Syntax Summary
Workshop Session

Q4 Creating Data

Creating Tables, Views and Indexes
Changing Data in Tables
Changing the Structure of Tables
Further Topics
Workshop Session

SAS SQL

Details:

166.66kb, pdf

Public Booking

Date Next Month

September 2010	October 2010	November 2010
-	8th	-