Accessing SAS from Microsoft Office Applications (SBIAMO)

Duration

1 day

Description

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

Learn how to:

access and filter existing SAS data
use SAS data sources in PivotTables
create customized bar charts and summary tables
use stored processes, SAS tasks, and wizards to create reports
create spreadsheets, documents, and slides from SAS output

Prerequisite Skills

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

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

Course Topics

SAS Business Intelligence and Course Introduction

SAS Business Intelligence Overview
overview of the SAS Add-In for Microsoft Office
introduction to the course data
introduction to the course scenarios

Exploring the SAS Add-In for Microsoft Office

using the SAS Add-In for Microsoft Excel
using the SAS Add-In for Microsoft Word and Microsoft PowerPoint
using the SAS Add-In to publish documents (self-study)

Inserting SAS Data into Microsoft Excel

SAS data set concepts and terminology
using SAS data sources with Microsoft Excel
using SAS data sources in PivotTables

Inserting SAS Results into Microsoft Office

an overview of stored processes
customizing the output style

Analyzing Data with SAS Tasks in Microsoft Office

overview of SAS tasks
list data task
one-way frequencies task
table analysis task
summary table task
bar chart task
interacting with an activeX graph (self-study)

Booking

Please contact the Education Team at SAS for the latest information on all SAS courses or to put your name on our specialised course waiting list.