Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-800-268-7737 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


SAS Enterprise Guide 2: Advanced Tasks and Querying

GK# 2529

Course Overview


This course is intended for experienced SAS Enterprise Guide users who want to learn more about advanced SAS Enterprise Guide techniques. In this course, you will learn how to use the Query Builder within SAS Enterprise Guide, including manipulating character, numeric, and date values. You will also learn how to convert variable type as well as build conditional expressions using the Expression Builder. Efficiency issues, such as joining tables and using a single query to group, summarize, and filter data is also addressed in this course.


  • Delivery Format:
  • Date:
  • Location:
  • Access Period:



Viewing outline for:

Classroom Live Outline

1. Introduction

  • Course overview
  • Course logistics

2. Using the Data Menu

  • Append Tables task
  • Split Columns task
  • Stack Columns task
  • Random Sample task
  • Sort Data task

3. Using Functions in the Query Builder

  • Introduction to SAS functions
  • Manipulating numeric values
  • Manipulating character values
  • Converting data type

4. Prompting and Conditional Processing

  • Multiple values prompts
  • Range prompts
  • Conditional processing of project steps

5. Recoding Data

  • Recoding values
  • Recoding values based on a condition
  • Writing CASE expressions
  • Creating and applying custom formats

6. Grouping and Filtering

  • Grouping and summarizing data
  • Including detail and summarized data
  • Filtering summarized data in groups

7. Learning More

  • SAS resources
  • Beyond this course

8. Additional Query Topics

  • Query options
  • Querying DBMS tables


Viewing labs for:

Classroom Live Labs

Exercises or hands-on workshops are included with most SAS courses.



Who Should Attend

  • Non-programmers with SAS Enterprise Guide experience
  • Experienced programmers with SAS Enterprise Guide experience
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 2 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 4 day

Request this course in a different delivery format.