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.

Classroom: Students attend classroom courses in one of our public training centers. You receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.

Live Web: Students attend Live Web classes using a Web browser and a telephone and interact with their instructor and fellow classmates in real time. Each student receives an e-mail with instructions on how to join the class three business days before the class begins. The instructions e-mail includes a link to download the course materials. Students need to download and print the course materials prior to class.

For Live Web, you must

• review and meet the general system requirements.
• complete the course exercises through our virtual lab. The virtual lab allows you to access the software used in class over the Internet, so that you do not need this software on your local machine.
• run this test to connect to a virtual lab session. If firewall problems prevent you from connecting to the virtual lab, then you will need the following software installed and configured in your environment to participate in the course exercises:
  • SAS Enterprise Guide 4.1 and Base SAS 8.2 or higher, both running on a PC (Windows 98 or higher required). Follow these steps to ensure that SAS Enterprise Guide and SAS are configured correctly.

Not sure if this course suits your needs or which delivery method is right for you? Give us a call at 800-333-7660 or send us e-mail. If you have suggestions for this course or would like for it to be offered at another training facility, let us know by adding to our Interest List.