Administering the SAS Add-In for Microsoft Office

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 Excel, Microsoft Word, and Microsoft PowerPoint. To see the power of SAS in Excel, Word, or PowerPoint:

In Microsoft Office 2000-2003, open the SAS menu.
In Microsoft Office 2007, click the SAS tab in the Ribbon. Several groups with related SAS tasks are displayed.

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, see the following:

In Microsoft Office 2000-2003, click SAS Help SAS Add-In for Microsoft Office Help.
In Microsoft Office 2007, click SAS Help SAS Add-In for Microsoft Office Help.
The product web page: http://support.sas.com/documentation/onlinedoc/addin/index.html.

Top of Page