Introduction to SAS® Enterprise Guide® 4

Objectives

By the end of the course Delegates will be able use the capabilities and features of EG4. They will be able to use the interface effectively and will have the ability to create projects that access data from various sources, manipulate data, analyse it and produce reports.

Description

This course focuses on how to access, manage, summarise, 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.

Statistical analysis tasks are covered on the Introduction to SAS® Enterprise Guide® 3: for Statistical Analysis course.

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.

SAS Modules Used

SAS Enterprise Guide 4

Course Topics

Getting Started

• Introducing SAS Enterprise Guide
• Course scenarios

Working with Data in a Project

• Introduction to 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

• 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
• Setting a filter and selecting columns
• Creating new columns with an expression
• Creating new columns by recoding values
• Joining tables
• Joining tables including non-matching rows

Creating Summarised Output

• Generating and exporting summary statistics
• Creating and applying custom formats
• Creating a tabular summary report
• Creating a graph
• Interacting with an ActiveX graph

Advanced Queries

• Controlling query output
• Creating parameterised queries
• Grouping and filtering data in a query

Working with Results and Automating Projects

• Customising the output style
• Combining results
• Updating results

Introduction to SAS Programming (Self-Study)

• Getting started with SAS syntax
• Editing SAS code
• Working with SQL syntax