SAS Enterprise Guide for Experienced SAS Programmers

Duration:

2 days

This course introduces experienced SAS programmers to SAS Enterprise Guide as an interface to write and sumbit code, as well as use the point-and-click tasks to generate queries, reports and graphics.

Learn how to

• Write, edit and submit SAS programs in SAS Enterprise Guide
• Use point-and-click tasks and wizards to access data and create queries, reports and graphics
• Customize task output by modifying the code that is generated by SAS Enterprise Guide
• Use the concept of SAS Enterprise Guide Project to combine SAS programs with point-and-click functionality, including automated exporting and scheduled updates.

Who should attend:

Experienced SAS programmers who want to learn the point-and-click functionality of SAS Enterprise Guide, including the intricacies of using it as a primary programming interface

Prerequisites

Before attending this course, you should have taken SAS Programming 1: Essentials or have equivalent experience. You are encouraged but not required to take SAS Programming 2: Data Manipulation Techniques or have equivalent experience. Students should have little or no prior exposure to SAS Enterprise Guide.

Course Contents

Getting Started

• Introducing SAS Enterprise Guide
• Benefits of SAS Enterprise Guide for SAS programmers
• Navigating the SAS Enterprise Guide environment
• Writing and submitting SAS programs

Working with Data in a Project

• Introduction to tabular data (self-study)
• Accessing local data
• Accessing remote data
• Importing text files
• Editing tables in the Data Grid (self-study)

Getting Started with Tasks

• Introduction to task dialog boxes
• Creating a listing report
• Creating a frequency report
• Creating a two-way frequency report (self-study)

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 (self-study)
• Joining tables
• Joining tables including non-matching rows (self-study)

Additional Query Topics (Self-Study)

• Controlling query output
• Grouping and filtering data in a query

Creating Summarized Output

• Generating summary statistics
• Creating a graph
• Interacting with an ActiveX graph (self-study)
• Creating a tabular summary report
• Creating and applying custom formats (self-study)

Working with Generated SAS Code

• Understanding the generated code
• Interacting with the generated code
• Enhancing titles and footnotes
• Conditional highlighting
• Getting help (self-study)

Using Project Parameters

• Defining project parameters
• Using parameters with tasks and queries
• Using parameters in SAS programs

Enhancing Results and Automating Projects

• Customizing the output style
• Combining results
• Managing projects

Controlling Output Formats (Self-Study)

• The Output Delivery System
• Customizing HTML output
• Customizing RTF output
• Customizing PDF output

Software Addressed

This course addresses the following software product(s): SAS Enterprise Guide.