SAS Add-In for Microsoft Office Overview

The SAS Add-In for Microsoft Office is a Component Object Model (COM) add-in. It extends Microsoft Office to use the power of SAS data access, analysis, and reporting directly from Microsoft Outlook, Excel, Word, and PowerPoint. To see the power of SAS in these applications, open the SAS tab or menu.
The SAS Add-In 4.3 and 4.305 for Microsoft Office supports the following products:
  • Microsoft Excel, Word, and PowerPoint 2003, 2007, and 2010
  • Microsoft Outlook 2007 and 2010
The SAS Add-In 5.1 for Microsoft Office supports the following products:
  • Microsoft Excel, Word, and PowerPoint 2007 and 2010
  • Microsoft Outlook 2007 and 2010
After you install the SAS Add-In for Microsoft Office, certain administrative tasks need to be completed. The administrative tasks are summarized in the following table.
Administrative Tasks for SAS Add-In for Microsoft Office
Administrative Task
Purpose of Task
Administer a connection profile
Add, modify, or delete a profile. Set the active profile.
Select a default server
Specify which server you want to access by default.
Administer profile configuration updates
Create a configuration update file that can be modified and used each time the Microsoft applications are initialized.
Administer files
Specify the location of the add-in administration files.
Administer roles
Limit access to certain features for certain users.
Grant library access
Administer access to registered libraries.
For additional information about using the SAS Add-In for Microsoft Office, right-click the SAS tab or menu in the Microsoft software and select Help. See also the product Web page: http://support.sas.com/software/products/addin/index.html .