Accessing SAS® Data from Microsoft® Office Applications

Duration:

1 day

Description

This course provides an overview of SAS Add-In for Microsoft Office and shows how it can be used to directly access SAS information from Microsoft Office applications.

You learn how to run SAS Stored Processes and use SAS tasks for processing data directly from inside a Microsoft Excel or Microsoft Word document. In addition, you will learn how to access and work with existing SAS data from Microsoft Excel.

Prerequisite Skills

No SAS experience or programming experience is required although you should have some experience using Microsoft Word and Excel. Specifically, you should be able to:

• open and save documents
• use the menus and toolbars to accomplish tasks
• navigate Word documents and Excel spreadsheets.

SAS Modules Used

SAS Add-In for Microsoft Office, SAS Enterprise Intelligence Platform, SAS Enterprise BI Server.

Course Topics

SAS Business Intelligence and Course Introduction

• SAS Business Intelligence overview
• introduction to the course data
• introduction to the course scenarios.

Exploring SAS Add-In for Microsoft Office

• overview of SAS Add-In for Microsoft Office
• using SAS Add-In for Microsoft Office in Excel
• using SAS Add-In for Microsoft Office in Word.

Inserting SAS Data into Microsoft Excel

• SAS data set concepts and terminology
• using SAS data sources with Microsoft Excel.

Inserting SAS Results into Microsoft Office

• an overview of stored processes
• customising the output style.

Analysing Data with SAS Tasks in Microsoft Office

• overview of SAS tasks
• list data task
• one-way frequencies task
• able analysis task
• bar chart task
• interacting with an ActiveX Graph (self-study).