Querying and Reporting using SAS Enterprise Guide (EGQR4)

Duration

2 days

Description

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.

Prerequisite Skills

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 Topics

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

Booking

Please contact the Education Team at SAS for the latest information on all SAS courses or to put your name on our specialised course waiting list.