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.

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

This course addresses SAS Enterprise Guide.

Students receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.