SAS(R) Enterprise Guide(R) 1: Querying and Reporting

Target group

Course structure

Getting Started

• Introducing SAS Enterprise Guide.
• Working with SAS Enterprise Guide projects.

Working with Data in a Project

• Understanding SAS data structures.
• Accessing data.
• Importing data files.

Getting Started with Tasks

• Introduction to tasks and wizards.
• Creating a frequency report.
• Generating different output formats.
• Creating a listing report.
• Filtering data in a task.
• Creating a graph.

Creating Simple Queries

• Filtering and sorting data.
• Creating new columns.
• Grouping and summarizing data.
• Joining tables.

Creating Summarized Output

• Generating summary statistics.
• Creating a summary table report.

Using Prompts in Tasks and Queries

• Prompting in projects.
• Creating and using prompts in tasks.
• Creating and using prompts in queries.

Customizing and Organizing Project Results

• Combining results.
• Updating and organizing projects.