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.

  • SAS Enterprise Guide® Introduction

    • Introduction to functionality and capability of SAS Enterprise Guide®
    • Working with the SAS Enterprise Guide interface
    • Create a sample report
    Introduction to functionality and capability of SAS Enterprise Guide

    Approximately delivery time: 1 hours

  • SAS Enterprise Guide® Accessing Data

    • Accessing Data with SAS Enterprise Guide®
    • SAS tables, RDBMS tables, Excel Spreadsheets, Text files and adhoc data

    Approximately delivery time: 2 hours

  • SAS Enterprise Guide® Summarisation and Reporting Tasks

    • Working with SAS Enterprise Guide® reporting tasks
    • Frequency and cros tabulation frequency reports
    • Data summarisation tasks
    • Cross tabulation summarised reports
    • Creating graphs and data exploration tasks

    Approximately delivery time: 4 hours

    Pre-requisite Topics

    SAS Enterprise Guide®
    SAS Enterprise Guide® Accessing Data
  • SAS Enterprise Guide® - Using SAS Functions and Formats Basics

    • How to use common SAS software functions to help with text search and manipulation, arithmetic operations and format lookups
    • Powerful date management functions
    • Using SAS software formats to change how data values are viewed

    Approximately delivery time: 3 hours

  • SAS Enterprise Guide® Filter and Query Basics

    • Filtering and querying data with SAS Enterprise Guide®
    • Using the SQL query builder task to perform basic data extraction
    • Filtering data in any SAS Enterprise Guide® task (SAS ver 9.2)

    Approximately delivery time: 1 hours

    Pre-requisite Topics

    SAS Enterprise Guide®
    SAS Enterprise Guide® Accessing Data
  • SAS Enterprise Guide® Querying - Intermediate

    • Joining multiple tables in your queries
    • Apply more complex filters
    • Summarise data using the query building functionality in SAS Enterprise Guide®

    Approximately delivery time: 1 hours

    Pre-requisite Topics

    SAS Enterprise Guide®
    SAS Enterprise Guide® Accessing Data
    SAS Enterprise Guide® Filter and Query Basics
  • SAS Enterprise Guide® Querying - Advanced

    • Using the expression builder utility to build expressions, new fields and complex filters using SAS software functions and formats
    • Using SQL CASE statements to build IF/THEN type logic
    • Create your own formats to validate data and create lookup values

    Approximately delivery time: 4 hours

    Pre-requisite Topics

    SAS Enterprise Guide®
    SAS Enterprise Guide® Accessing Data
    SAS Enterprise Guide® - Using SAS Functions and Formats Basics
    SAS Enterprise Guide® Filter and Query Basics
    SAS Enterprise Guide® Querying - Intermediate
  • SAS Enterprise Guide® Using Prompts

    • Using prompts for passing dynamic and static parameters to tasks and programs in your SAS Enterprise Guide® project

    Approximately delivery time: 1 hours

  • SAS Enterprise Guide® Data manipulation tasks

    • Data manipulation and summarisation tasks in SAS Enterprise Guide®
    • Sort, summarise, append, transpose and split data

    Approximately delivery time: 1 hours

    Pre-requisite Topics

    SAS Enterprise Guide®
    SAS Enterprise Guide® Accessing Data
  • SAS Enterprise Guide® Controlling Output Format

    • Customising your HTML, PDF, RTF reports, reporting to Excel
    • Standardise the look and feel of your reports by modifying and creating your own stylesheet to control colours, font, pictures etc...
    • Managing your projects with:-
      •  comments, Ordered execution lists, Scheduling, Manually linking tasks, Organise your project with multiple pages

    Approximately delivery time: 1 hours

    Pre-requisite Topics

    SAS Enterprise Guide®
    SAS Enterprise Guide® Summarisation and Reporting Tasks
  • SAS Enterprise Guide® and SAS Software Code

    • Generating SAS software program code with SAS Enterprise Guide®
    • Writing and using your own SAS software programs in SAS Enterprise Guide®

    Approximately delivery time: 1 hours

  • Intergrating SAS Enterprise Guide® with your SAS Programs

    As many companies are moving toward using SAS Enterprise Guide as their standard SAS programming interface, it is handy to know the benefits and new capabilities this brings along with it.

    • Using the Code task to create an externally stored code module anyone can use.
    • Imbedding and extracting SAS code from your project
    • Utilising prompted macro parameters in your code tasks.
    • Overview of turning an EG task into a stored process. (overview only)

    Approximately delivery time: 1 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