• Print  |
  • Feedback  |

Knowledge Base

SAS Products

SASŪ Add-In for Microsoft Office

Product Specific Resources
News about the SAS Add-In for Microsoft Office
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


Overview

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.

Visit our general product information page on www.sas.com for more information.




System Requirements at a Glance

The SAS Add-In for Microsoft Office is part of the SAS software offerings, SAS Enterprise BI Server and SAS Enterprise Miner, which run in the following operating environments: Microsoft Windows, UNIX, and IBM z/OS.

Documentation
  • SAS Press Books
  • All SAS Add-In for Microsoft Office titles in online bookstore
  • Most Used SAS Documentation 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 SAS Add-In for Microsoft Office


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.

Samples and SAS Notes
SAS Add-In 5.1 Samples
These 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.
Highlighted SAS Notes


Need help?

Visit the Support page to access various self-help and assisted-help resources or submit a problem through the SAS Technical Support Form.

Conversations
Integration with Microsoft Office Forum

Share your experiences, questions and ideas with other users.

Enter the forum