SAS SQL Course

Home > Training > SAS SQL

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

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.

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

Duration
1 day.

Course Topics

Introduction Concepts The SAS Data Model	Selecting Data The Select Statement Controls and Enhancements Analysis on Groups Nested Subqueries Syntax Summary Workshop
Combining Data Inner Joins Outer Joins Complex Queries Set Operations Workshop	Creating Data Creating Tables, Views and Indexes Changing Data in Tables Changing the Structires of Tables Further Topics Workshop

Scorpio can organise this course at your site or using training venues in Sydney, Canberra, Melbourne, Brisbane, Adelaide, Perth, Darwin or Hobart. For additional information, please contact us: info@scorpio.net.au

Training
- On-site courses
- On-site courses fees
- On-the-job training
Courses
- Getting Started SAS
- SAS Fundamentals
- SAS Programming
- SAS Report Writing
- Advanced SAS
- SAS Macro
- SAS SQL
- Using SAS/STAT
- Using SAS/GRAPH
- V6 to V8 Base SAS