Advanced Querying Using SAS Enterprise Guide

Who Should Attend?

Experienced SAS Enterprise Guide users.

Description

This course focuses on using the Query Builder within SAS Enterprise Guide to build more complex queries.

Learn how to

• Use functions to manipulate character and numeric data
• Use functions to work with SAS dates
• Convert data type from character to numeric and from numeric to character
• Create new columns using case logic
• Replace multiple tasks with a single query.

Duration

1 Day

Prerequisites

Before attending this course, you should have taken the Querying and Reporting Using SAS Enterprise Guide course or completed the Getting Started Tutorial within SAS Enterprise Guide.

SAS Modules Used

SAS Enterprise Guide.

Course Topics

Introduction

• advanced querying overview
• reviewing query builder basics

Using Functions

• general use of functions
• accessing SAS Help for functions

Manipulating Numeric Values

• calculating summary statistics within each row
• reducing numeric precision
• generating random numbers (self-study)

Manipulating SAS Date Values

• creating a SAS date value
• extracting information from a SAS date value
• calculating date intervals

Converting Data Type

• converting character to numeric values
• converting numeric to character values

Manipulating Character Values

• extracting character values
• combining character values
• modifying character case

Recoding Columns

• recoding values
• using the CASE expression

Summarizing Data in a Query

• grouping and summarizing data
• filtering summarized data

Additional Topics (Self-Study)

• joining tables
• querying DBMS tables