There is a new version of this course. Please see SAS® Enterprise Guide® 1: Querying and Reporting.

This course is for users who do not have SAS programming experience 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. It does not address writing SAS code or statistical concepts. This course serves as a prerequisite for the &egprg1 course, which does include SAS programming techniques. It also serves as a prerequisite for the SAS® Enterprise Guide®: ANOVA, Regression, and Logistic Regression course which teaches statistical concepts using SAS Enterprise Guide.

Learn how to

• access and manipulate local and remote data of various types
• create queries that filter and summarize data, compute new columns, and join multiple tables
• create frequency and tabular reports
• create interactive graphs
• automate output results.

Who should attend

Data, business, and statistical analysts who have licensed or are considering licensing SAS Enterprise Guide or SAS Analytics Pro and would like training to help get started with data access, management, and analysis

Formats available	Standard Duration
Classroom:	2.0 days
Live Web Classroom:	5 half-day session(s)	System Requirements

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.

This course addresses SAS Enterprise Guide, SAS Analytics Pro software.

Getting Started

• introducing SAS Enterprise Guide
• course scenarios

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 tasks and wizards
• creating a frequency report
• generating HTML, PDF, and RTF output
• creating a listing report
• filtering data in a task
• creating a graph

Creating Simple Queries

• introduction to querying data
• filtering and sorting data
• creating new columns with an expression
• grouping and summarizing data in a query
• joining tables
• joining tables including nonmatching rows (self-study)
• creating new columns by recoding values (self-study)

Creating Summarized Output

• generating summary statistics
• creating and applying custom formats
• creating a summary report with the Summary Tables task
• creating a summary report with the List Report Wizard (self-study)

Using Prompts in Tasks and Queries

• prompting in projects
• creating and using prompts in tasks
• creating and using prompts in queries

Working with Results and Automating Projects

• customizing the output style
• combining results
• updating results

Learning More

• SAS resources
• beyond this course