Advanced Querying Using SAS Enterprise Guide (EGAQ4)

Duration

1 day

Description

This course 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.

Prerequisite Skills

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.

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

Booking

Please contact the Education Team at SAS for the latest information on all SAS courses or to put your name on our specialised course waiting list.