SAS Enterprise Guide – Part 1

Description

SAS Enterprise Guide 1: Querying and Reporting is for users without SAS programming experience who need to access data from different sources, manage and summarize it, and present results in reports and charts. It focuses on menu-driven tasks in the SAS Enterprise Guide point-and-click interface.

This three-day course covers data analysis, cleaning, processing, joining tables and creating reports and charts. Participants learn to perform analytical calculations, reporting and visualization in SAS, including work with datasets that are difficult to handle in Excel because of row limits or performance constraints.

This course is a prerequisite for SAS Enterprise Guide – Part 2: Advanced Tasks and Querying.

What Will You Learn?

• Navigating SAS Enterprise Guide and using its interface
• Importing Excel tables into SAS and exporting SAS tables to Excel
• SAS functions
• Joining, filtering and sorting tables
• Creating visual reports
• Accessing and modifying local and remote data
• Queries that filter and summarize data, calculate columns and join tables
• Automating output

Who Should Attend?

• Those who want to analyze data with SAS and create reporting workflows
• Data, business and statistical analysts using or considering SAS Enterprise Guide or SAS Analytics Pro
• Excel users who want to work more effectively with large datasets

Outline

Prerequisites

There are no prerequisites.