Accessing SAS from Microsoft Office Applications

Classroom duration: 1.0 day Live Web duration: 3 half-day sessions Please note the System Requirements below. Course fee: $475 EPTO units: 0.9 CEUs: 0.6

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.

Who should attend

Microsoft Office users who want to work with SAS data to create reports and perform analyses

Expand/Collapse All Expand All Collapse All Print version

Prerequisites

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 Contents

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)

Software

This course addresses SAS Add-In for Microsoft Office, SAS Intelligence Platform.

Course Materials

Classroom: Students attend classroom courses in one of our public training centers. You receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.

Live Web: Students attend Live Web classes using a Web browser and a telephone and interact with their instructor and fellow classmates in real time. Each student receives an e-mail with instructions on how to join the class three business days before the class begins. The instructions e-mail includes a link to download the course materials. Students need to download and print the course materials prior to class.

System Requirements

For Live Web, you must

review and follow the general system requirements.
complete the course exercises through our virtual lab. The virtual lab allows you to access the software used in class over the Internet, so that you do not need this software on your local machine.
run this test to connect to a virtual lab session. If firewall problems prevent you from connecting to the virtual lab, then you will not be able to participate in the course exercises. Using your organization's BI environment is not an option for completing the course exercises.

Share Your Thoughts

Not sure if this course suits your needs or which delivery method is right for you? Give us a call at 800-333-7660 or send us e-mail. If you have suggestions for this course or would like for it to be offered at another training facility, let us know by adding to our Interest List.

This page was created using SAS software.

Learning Center

Stay in Touch

Not sure what course to take?

Submit Your Course Requests

On-site Pricing