SAS Products
SASŪ Add-In for Microsoft Office
About SAS Add-In for Microsoft Office
The SAS Add-In for Microsoft Office is a Component Object Model (COM) add-in that extends Microsoft Office by enabling you to use the power of SAS analytics and access data directly from Microsoft Excel, Microsoft Word, Microsoft PowerPoint, and Microsoft Outlook.
The functionality that is available for the SAS add-in varies among Microsoft applications. In general, the functionality of the SAS add-in is the same among Excel, PowerPoint, and Word. In all of these applications, you can run analyses, generate reports, and share this SAS content with other users at your site. In addition, in Microsoft Excel, you can open and edit data sources. In Microsoft Outlook, you can monitor reports and dashboard indicators. You can use the native functionality in Outlook to share these reports and dashboard indicators with other users at your site. However, you cannot create new reports or run a SAS task in Outlook.
The SAS Add-In for Microsoft Office is part of SASŪ Enterprise BI Server and SASŪ Enterprise Miner™.
The most current release is SAS Add-In for Microsoft Office 5.1.
News
The SAS Add-In 5.1 for Microsoft Office Is Now Available
The SAS Add-In 5.1 for Microsoft Office runs on Microsoft Office 2010 and 2007 and can be run on either a SAS 9.2 or a SAS 9.3 server.
The SAS Add-In 5.1 for Microsoft Office is now available as either a 32-bit or a 64-bit application. If you are using a 32-bit Microsoft Windows operating system, then you must use the 32-bit version of the SAS Add-In for Microsoft Office. If you are using a 64-bit Windows operating system, then you can run either the 32-bit or the 64-bit version of the SAS Add-In for Microsoft Office.
Here are some key features and enhancements that are available in Microsoft Outlook:
- role-based settings to manage the availablity of features.
- integration with instant messaging tools, so you can use the functionality of Microsoft Office Communicator or Microsoft Lync while viewing the results from a report.
- the ability to add and view comments for a specific report. You must be running SASŪ Web Report Studio 4.31 M1 to use the commenting functionality.
In Microsoft Excel, a new Quick Start interface has these tools:
- a Task Gallery that shows a sample of the results that are generated by each SAS task
- the Automatic Chart panel where the SAS Add-In for Microsoft Office creates bar charts, bubble plots, line plots, pie charts, or scatter plots based your role assignments
- the Quick Stats panel where the SAS Add-In for Microsoft Office quickly calculates the basic statistics and creates basic graphs based on the input data source
Visit our general product information page on www.sas.com for more information.
Online Documentation
Purchase from Bookstore
Technical Papers
Free Online Documentation
- Most recent release for SAS Add-In for Microsoft Office
SAS Add-In 5.1 for Microsoft Office
- What's New in the SAS Add-In 5.1 for Microsoft Office [HTML]
- SAS Add-In 5.1 for Microsoft Office: Getting Started in Microsoft Excel, Microsoft Word, and Microsoft PowerPoint [PDF] (5.48MB)
- "Administering the SAS Add-In for Microsoft Office" in the SAS 9.3 Intelligence Platform: Desktop Application Administration Guide [HTML]
- When the SAS Add-In for Microsoft Office is installed, the Help is accessible in the following ways:
- In Microsoft Office 2010 or Microsoft Office 2007, select the SAS tab in the Ribbon. In the Tools group, click Help and select Help for the SAS Add-In for Microsoft Office.
- In Microsoft Outlook 2010, select the SAS tab in the Ribbon. In the Tools group, click Help and select Help for the SAS Add-In for Microsoft Office.
- In Microsoft Outlook 2007, select Help -> Help for the SAS Add-In for Microsoft Office.
- All online documentation for supported releases of SAS Add-In for Microsoft Office [HTML]
Bookstore
- SAS Add-In for Microsoft Office titles in online bookstore [HTML]
- Featured Titles
Technical Papers
- SAS Technical Papers for SAS Add-In for Microsoft Office [HTML]
Need help?
SAS Publishing Representatives are available in the U.S. from 8-5 ET to answer your documentation questions. Contact us at 1-800-727-3228 or e-mail.
Training
Need help?
Curriculum consultants are available in the U.S. from 9-5 EST. Contact us at 1-800-333-7660 or e-mail.
International customers, please contact your country office.
Online Support Resources
This page contains online support resources that are specific to this product. Visit the Support page to access various self-help and assisted-help resources or submit a problem through the SAS Technical Support form.
Downloads
Highlighted Samples
Notes
Videos
Downloads
Hot Fixes by Release
Highlighted Samples
- Support for the SAS Add-In for Microsoft Office in Microsoft Office 2010
- An error occurs when the SAS Add-In 4.3 for Microsoft Office and the SAS Add-In 4.2 for Microsoft Office are installed side by side
- SAS menus do not appear in Office programs when the SAS Add-In 4.3 for Microsoft Office is installed on a Windows Server 2008 32-bit computer
- SAS Add-In for Microsoft Office and SAS Enterprise Guide 4.3 cannot display prompted reports from SAS Web Report Studio 4.2
Notes
SAS Add-In 5.1 SamplesThese samples demonstrate some of the functionality within the SAS Add-In for Microsoft Office 5.1. These samples also show how the SAS add-in can use Visual Basic to create and manage SAS Content inside Microsoft Office. The samples are contained in a zip file. Open the README file for more information about how to download the zip file as well as a description of each sample.
SAS Add-In 4.3 Samples
These samples demonstrate some of the functionality within the SAS Add-In for Microsoft Office 4.3. These samples also show how the SAS add-in can use Visual Basic to create and manage SAS Content inside Microsoft Office. The samples are contained in a zip file. Open the README file for more information about how to download the zip file as well as a description of each sample.
Videos
- Creating and Customizing SAS Styles
Air date: August 2012 - Creating and Managing SAS Favorites
Air date: August 2012 - Saving Steps with SAS Templates
Air date: August 2012
 |
Integration with Microsoft Office ForumShare your experiences, questions and ideas with other users. |
