Accessing SAS from Microsoft Office Applications

Duration: 1.0 day
Course fee: $660
EPTO units: 1
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

Students receive a hardcopy of the course notes.

Share Your Thoughts

Are there additional topics you'd like for this course to address? Would you like for this course to be offered at another training facility? Let us know by adding to our Interest List.

Course fee and EPTO units will differ for on-site training.

This page was created using SAS software.

-	Public
-	On-site training
-	One-to-one Mentoring
-	Courses by Industry Experts
-	Targeted Learning
-	ABM Training
-	TPS Service
-	Find a Course
-	Register now
-	Course list
-	Curriculum paths
-	Locations
-	Special Offers