There is a new version of this course. Please see Accessing SAS from Microsoft Office Applications.

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

• 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

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.

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

• 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

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

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