Scorpio Software Services Logo Scorpio Software Services    
 
Home > Training > SAS SQL Scorpio Consultancy SAS Training Products Company Information Contact Details Papers and Events Testimonials
SAS Training and SAS Courses
SAS® SQL Course

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

     
     

    Home | Consultancy | Training | Products | Company | Contact | Papers | Testimonials
    © 2003 Scorpio Software Services. All rights reserved. Terms of use