Querying, Reporting, and Analyzing Data Using SAS Enterprise Guide
Overview
SAS Enterprise Guide is an intuitive point-and-click interface that enables you to quickly and efficiently access, manage, analyze, and present your data without knowing any SAS programming.
This course enables you to select the version of SAS Enterprise Guide software you are using and the content of the course changes to correspond to your selected version. The SAS Enterprise Guide 4.1 version of the course enables you to practice in a simulated SAS environment and requires you to have the latest version of Macromedia Flash Player installed. The SAS Enterprise Guide 2.0 and 3.0 lessons require you to have the corresponding version of SAS Enterprise Guide software installed in order to do the practices. You can also substitute SAS Learning Edition 2.0 for SAS Enterprise Guide 2.0 or SAS Learning Edition 4.1 for SAS Enterprise Guide 4.1.
Learn how to
- create and modify reports
- query data
- customize reports
- perform statistical analyses.
Who should attend
Analysts and statisticians who want to use the menu-driven tasks in SAS Enterprise Guide
Approximate duration: 8 hours
License period: 365 days
Course Outline
Getting Started with SAS Enterprise Guide
- Explore the Main Windows
- Set Up a Project and Work with Data
- Import Data From a Text File
- Create and Modify a Report
- Create a Bar Chart
- Join Tables by Using a Query
- Generate Reports From the Query
Querying Data Using SAS Enterprise Guide
- What Is a Query?
- Using the Query Builder
- Specifying a Result Format
- Starting a Query
- Working with Columns in a Query
- Subsetting Data in a Query
- Joining Tables in a Query
- Joining Tables Manually and Replacing Values
- Running Tasks against Query Output
- Creating Queries That Accept Parameters
- Grouping and Filtering Data in a Query
- Using Outer Joins
Creating and Customizing Reports Using SAS Enterprise Guide
- Preparing Data for Reports
- Setting Options for Results
- Creating List Reports
- Creating One-Way Frequency Reports
- Creating Summary Reports
- Creating Graphs
- Setting Options for Graphs
- Combining Reports
- Using Styles to Customize HTML Reports
- Creating and Applying Custom Formats
- Using Traffic Lighting in a Summary Report
Performing Statistical Analyses Using SAS Enterprise Guide: Examples
- Summary Statistics
- Distribution Analysis
- t-Tests
- One-Way Analysis of Variance
- Simple Linear Regression
- Two-Way Analysis of Variance
- Analysis of Covariance
- Control Charts for Measurement Data
- Control Charts for Attribute Data
Course Materials
Students have unlimited 24/7 access to the interactive multimedia course on the Web for one year.
The course requires only a standard Web browser and a free Flash plug-in. The course includes data
that can be downloaded, printable lesson summaries, a Quick Reference Guide, practices and solutions,
step-by-step demonstrations, and a Certificate of Completion.
System Requirements
You should
- use Internet Explorer 6.0 or later or Firefox 1.5 or later, with JavaScript and cookies enabled
- have the latest version of Macromedia Flash Player installed
- have base SAS software visible on the same machine that you are taking the training on so that you can practice your new skills in your own SAS environment.
.
Share Your Thoughts
If you have suggestions for this course, let us know by adding to our
Interest List.
This page was created using SAS software.