Querying and Reporting Using SAS Enterprise Guide

Duration: 2.0 days
Course fee: $1,320
EPTO units: 2
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

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

Share Your Thoughts

Are there additional topics you'd like for this course to address? Would you like for this course to be offered at another training facility? Let us know by adding to our Interest List.

Course fee and EPTO units will differ for on-site training.

This page was created using SAS software.

-	Public
-	On-site training
-	One-to-one Mentoring
-	Courses by Industry Experts
-	Targeted Learning
-	ABM Training
-	TPS Service
-	Find a Course
-	Register now
-	Course list
-	Curriculum paths
-	Locations
-	Special Offers