Querying and Reporting Using SAS Enterprise Guide

Please note the System Requirements below. CEUs: 1.2
(This course is not currently scheduled.)

This course focuses on how to access, manage, summarize, and present data using SAS Enterprise Guide. The course teaches students how to navigate the menu-driven interface of SAS Enterprise Guide to accomplish tasks such as accessing local SAS and Microsoft Excel tables and remote relational databases; creating user-defined formats; managing, manipulating, and joining data using the SQL Query Builder; generating descriptive statistics, tabular summary reports, and ActiveX graphs; and automating and scheduling tasks. This course does not cover statistical analysis tasks.

Who should attend

This course is designed for end users who are not programmers but who need to retrieve information from different sources, summarize it, and present it in tables and graphs.

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

introducing tabular data
adding a local SAS table
accessing remote data
adding local data in other software formats
importing text files
working with tables in the Data Grid (self-study)

Getting Started with Tasks

introducing task dialogs
creating a listing report
creating a frequency report
creating a two-way frequency report

Creating Simple Queries

introducing the Query task
setting a filter and selecting columns
creating new columns in a query
replacing values in a query
joining tables
performing outer joins (self-study)

Creating Summarized Output

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

Creating 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
building a Process Flow Diagram
automating projects and processes

Introducing SAS Programming

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 3.0 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.

Available for on-site training or can be scheduled at any SAS training facility

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