SAS Enterprise Guide 2: Advanced tasks and Querying

2 Days

Description

This course is intended for experienced SAS Enterprise Guide users who want to learn more about advanced SAS Enterprise Guide techniques. It focuses on using the Query Builder within SAS Enterprise Guide, including manipulating character, numeric, and date values; converting variable type; and building conditional expressions using the Expression Builder. This course also addresses efficiency issues, such as joining tables and using a single query to group, summarize, and filter data.

Skills Gained

  • use tasks to transpose, stack, rank, and create a random sample of your data
  • use functions to convert the data type from character to numeric and from numeric to character
  • use conditional logic in the Query Builder to create new columns
  • use multiple value prompts.

Who Can Benefit

  • Non-programmers with SAS Enterprise Guide experience, as well as experienced programmers with SAS Enterprise Guide experience

Upcoming Classes

Classroom Live
October 19, 2017

Philadelphia, PA
$1,100.00
2 Days    9:00am - 5:00pm
view class details and enroll
Classroom Live
October 24, 2017

Washington, DC
$1,100.00
2 Days    9:00am - 5:00pm
view class details and enroll
Classroom Live
October 30, 2017

New York, NY
$1,100.00
2 Days    9:00am - 5:00pm
view class details and enroll
Virtual Classroom Live
October 31, 2017

$1,100.00
2 Days    1:00pm EST - 4:30pm EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

Introduction

  • course overview
  • course logistics

Using the Data Menu

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

Using Functions in the Query Builder

  • introduction to SAS functions
  • manipulating numeric values
  • manipulating character values
  • converting data type

Prompting and Conditional Processing

  • multiple values prompts
  • range prompts
  • conditional processing of project steps

Recoding Data

  • recoding values
  • recoding values based on a condition
  • writing CASE expressions
  • creating and applying custom formats

Grouping and Filtering

  • grouping and summarizing data
  • including detail and summarized data
  • filtering summarized data in groups

Learning More

  • SAS resources
  • beyond this course

Additional Query Topics

  • query options
  • querying DBMS tables

Upcoming Classes

Classroom Live
October 19, 2017

Philadelphia, PA
$1,100.00
2 Days    9:00am - 5:00pm
view class details and enroll
Classroom Live
October 24, 2017

Washington, DC
$1,100.00
2 Days    9:00am - 5:00pm
view class details and enroll
Classroom Live
October 30, 2017

New York, NY
$1,100.00
2 Days    9:00am - 5:00pm
view class details and enroll
Virtual Classroom Live
October 31, 2017

$1,100.00
2 Days    1:00pm EST - 4:30pm EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

  • Before attending this course, students should understand how to navigate the SAS Enterprise Guide environment, create projects, add data sources, accomplish basic analysis and reporting using tasks, and create queries. You can gain this knowledge by taking the SAS(R) Enterprise Guide(R) 1: Querying and Reporting course or by completing the Getting Started tutorial in SAS Enterprise Guide. No SAS or SQL programming experience is required.

Upcoming Classes

Classroom Live
October 19, 2017

Philadelphia, PA
$1,100.00
2 Days    9:00am - 5:00pm
view class details and enroll
Classroom Live
October 24, 2017

Washington, DC
$1,100.00
2 Days    9:00am - 5:00pm
view class details and enroll
Classroom Live
October 30, 2017

New York, NY
$1,100.00
2 Days    9:00am - 5:00pm
view class details and enroll
Virtual Classroom Live
October 31, 2017

$1,100.00
2 Days    1:00pm EST - 4:30pm EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date