Querying and Reporting Using SAS Enterprise Guide

Classroom duration: 2.0 days Live Web duration: 5 half-day sessions Please note the System Requirements below. Course fee: $950 EPTO units: 1.8 CEUs: 1.2

This course is designed for analysts and statisticians who are not programmers but need to access, manage, and summarize data from different sources, and present results in tables and graphs. This course focuses on using the menu-driven tasks in SAS Enterprise Guide, the point-and-click interface to SAS, to create queries and reports. To learn SAS programming techniques, you should attend the SAS Programming I: Essentials course.

Learn how to

access and manipulate local and remote data
create simple and advanced queries
create frequency and tabular reports
create static and interactive graphs
automate and schedule tasks.

Who should attend

Analysts and statisticians who want to use the menu-driven tasks in SAS Enterprise Guide

Expand/Collapse All Expand All Collapse All Print version

Prerequisites

This course is designed for end users with no programming experience or SAS knowledge. Before attending this course, you should be familiar with Windows and other software, such as Microsoft Office or spreadsheet programs.

Course Contents

Getting Started

introducing SAS Enterprise Guide

Working with Data in a Project

introduction to tabular data
accessing local data
accessing remote data
importing text files
editing tables in the Data Grid (self-study)

Getting Started with Tasks

introduction to task dialogs
creating a listing report
creating a frequency report
creating a two-way frequency report
using variable parameters in tasks

Creating Simple Queries

introduction to the Query task
selecting columns and filtering rows
creating new columns with an expression
creating new columns by recoding values
joining tables
joining tables including non-matching rows

Creating Summarized Output

generating summary statistics
creating and applying custom formats
creating a tabular summary report
creating a graph
interacting with an ActiveX graph (self-study)

Advanced Queries

controlling query output
creating parameterized queries
grouping and filtering data in a query (self-study)

Working with Results and Automating Projects

customizing the output style
combining results
updating results

Introducing SAS Programming (Self-Study)

getting started with SAS syntax
editing SAS code
working with SQL syntax

Software

This course addresses SAS Enterprise Guide.

Course Materials

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.

System Requirements

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.

Share Your Thoughts

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.

This page was created using SAS software.

Learning Center

Stay in Touch

Not sure what course to take?

Submit Your Course Requests

On-site Pricing