This course shows how to build reports and analyze data using the SAS Add-In for Microsoft Office. Learn how to

• view and interact with several types of reports from Microsoft Office applications
• access various types of data from Microsoft Excel
• interact with multidimensional data
• run SAS analyses.

Who should attend Information consumers Formats available Duration
: 7 hours/180 day license

No SAS experience or programming experience is required, although you should have some computer experience. Specifically, you should be able to

• log on and off a computer and use a keyboard or mouse
• open and save documents using Microsoft Word and Microsoft Excel
• use the menus and toolbars to accomplish tasks in Word and Excel
• navigate Word documents and Excel spreadsheets
• use a web browser to access information.

This course addresses SAS Add-in for Microsoft Office, SAS Analytics Platform software.

Getting Started with the SAS Add-In for Microsoft Office

• exploring the SAS Add-In for Microsoft Office
• examining the platform for SAS Business Analytics
• discussing the course environment and data

Working with Data Sources in Microsoft Excel

• understanding SAS data
• accessing data in the SAS Add-In for Microsoft Office
• exploring data characteristics for a SAS table
• opening a SAS information map into Microsoft Excel
• interacting with multidimensional reports

Running Analyses Using the SAS Add-In for Microsoft Office

• exploring SAS task and wizard features
• creating a one-way frequency analysis
• creating a summary table
• creating graphical analyses with charts and plots

Presenting Information Using the SAS Add-In for Microsoft Office

• accessing SAS reports and SAS stored processes
• controlling and managing SAS add-in output
• working with templates and SAS favorites

EYAMO714.