SAS Enterprise Guide
Audience

This course is designed for Users as an introduction to Enterprise Guide software.

Objectives

This course is an introduction to Enterprise Guide Software, a point and click interface to the SAS System. After the course, attendees will be able to use Enterprise Guide to create projects, access, manage and manipulate their data, construct queries, run tasks, create and customise graphs and produce process flow diagrams.

This course is designed to be used with SAS Enterprise Guide 4.3 and above.

Topics:

lntroduction

  • What is SAS?
  • What is SAS Enterprise Guide?
  • An Example SAS Enterprise Guide Project
  • Introduction to the Environment
  • Opening and Viewing Data
  • What is a Library?
  • Workshop Session

Filtering and Sorting

  • Filter and Sort vs Query Builder and Sort Task
  • Selecting Variables
  • Filtering
  • Advanced Edit
  • Sorting
  • Controlling Results
  • Additional Options
  • Workshop Session

Enterprise Guide Projects

  • Project Handling
  • Process Flow Window
  • Working with SAS Programs
  • Workshop Session
  • Joining Tables of Data

    • Introduction to the Query Builder
    • Joining Tables
    • Workshop Session

    Working with Tasks

    • Overview of Tasks
    • Selecting Data for Tasks
    • Adding Tasks to a Project
    • Assigning Variables to Roles and Running Tasks
    • Viewing Task Output and Log
    • Customising SAS Code Behind Tasks (Reference)
    • Task Templates
    • Conditional Processing
    • Workshop Session

    Computing New Columns

    • Creating Computed Columns
    • Computing Summary Statistics
    • Calculations with Date and Time
    • Additional Query Builder Options
    • Workshop Session
    • What is a Library?
    • Workshop Session

    Managing Data

    • Opening Data in Enterprise Guide SAS?
    • Importing Data into Enterprise Guide
    • Exporting Data from Enterprise Guide
    • Creating and Applying Formats
    • Manipulating Data
    • Workshop Session

    Describing and Reporting Data

    • Describing Data
    • Visualising Data
    • Style Manager
    • Create a Report from Existing Results
    • Workshop Session

    Prompts

    • Using the Prompts Manager
    • Creating Prompt Driven Queries
    • Using Date Values with Prompts
    • Workshop Session
  • Register Online