The following course and knowledge testing topics can be mixed and matched in any practical combination to suit your needs. Try out the Course Designer or Test Designer wizards to give it a go yourself. Save what you put together without obligation and get a quote and book whenever you like.

  • Efficiency Techniques - Identifying problems

    • Four guideline rules to achieving SAS software program efficiency
    • Techniques to measure program efficiency
    • Understanding the implications of processing order and technique to gain maximum benefit

    Approximately delivery time: 1 hours

  • Advanced SQL Indexes,integrity constraints, union joins and nested sub queries

    This topic is an extension to the basic and intermediate level SAS SQL courses. Where we focus on more advanced techniques of programatically applying

    • data integrity rules (Integrity constraints)
    • Primary, Forign and Surrogate key generation and application
    • Index theory and usage
    • The use of nested sub queries in Select and From clauses
    • Appending data with SQL Unions
    • Controlling joins with multiple tables
    • Processing implications on complex joins
    • SQL Passthru queries for seamless and optimal data extraction from other Relational Databases

    Approximately delivery time: 6 hours

    Pre-requisite Topics

    SAS® Programming - Basics
    Proc SQL Basics
    SAS® Programming - Intermediate
    Proc SQL Intermediate - Calculations functions, formats and conditional logic
  • Efficiency Techniques - Using SAS indexes

    • Using SAS indexes to improve up processing efficiency
    • Creating and managing indexes
    • Indexes in Datastep and SQL

    Approximately delivery time: 2 hours

    Pre-requisite Topics

    SAS® Programming - Intermediate
    SAS® Level 2 Controlling data flow in the Data Step
    SAS® Level 2 Intermediate Data Step processing
    SAS® Level 2 Accumulating totals within the Data step
    SAS® Level 2 Data Step Array processing
    SAS® Level 2 Data Summarisation & Reporting Proceedures
  • Advanced User written formats for table lookups and nested lookups

    • Using user written formats to perform data validation and table lookup tasks
    • Controlling included and excluded values in format ranges
    • Loading data tables into user written formats
    • User written format nesting for multiple linked format lookups

    Approximately delivery time: 2 hours

  • Data step "Hash objects" for super speedy, high volume table lookups

    The "Data Hashing" capability from version 9 of SAS has completely redefined how fast you can perform table lookups and simple table joins.

    Here you will learn how to control this utility to perform super fast data validation, table lookup and merge functions with minimal I/O operations.

    Approximately delivery time: 3 hours

  • Efficiency Techniques - Views, Data compression, Field types

    • Storage considerations for creating indexes
    • Usage and maintenance considerations for Data step and Proc SQL Views.
    • Data Compression and options to control file / buffer memory allocations.

    Approximately delivery time: 2 hours

  • Dataset Efficiency - Using GDG's to access and update versioned tables

    GDG's (Generation data groups) have been in common use on mainframes for years. But you can make use of this facility in any SAS environment. Perfect for regularly updated or versioned data tables. For example. GDG's allow you to access the last generation of a nightly or weekly data capture, or easily specify the last 7 generations of data to be concatenated into a single data source.

    Approximately delivery time: 2 hours

YourTeamPlayer onsite SAS® Software Training

Entirely customised SAS® Software education

All courses are at YOUR site
All courses use YOUR DATA
All use YOUR computing environment
Only YOUR staff in attendance
Only dealing with YOUR data issues