Clients in the SAS Intelligence Platform

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. It enables you to harness the power of SAS analytics; to access relational data sources directly from Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Outlook; and to create reports within Microsoft Office. You can use the SAS Add-In for Microsoft Office for the following tasks:

dynamically execute stored processes and SAS tasks.
analyze SAS or Excel data by using SAS tasks.
embed and refresh the results of your stored processes and SAS tasks in your documents, spreadsheets, and presentations.
access and view SAS data sources or any data source that is available from your SAS server. There is no size limit on the SAS data sources that you can open.
filter your data using an intuitive user interface or using an advanced SQL editor.
sort your data by an unlimited number of variables.
send results from one Microsoft Office application to another. For example, you can send an analysis result that was created in Microsoft Excel to Microsoft Word or PowerPoint; and you can send reports from Microsoft Outlook to Excel, Word, or PowerPoint. When sending results, you can specify whether the results can be refreshed or whether they should be static.
share results by sending e-mail, scheduling meetings, or assigning tasks in Microsoft Outlook.

For more information, see the Help for the SAS Add-In for Microsoft Office. For information about administrative tasks associated with SAS Add-In for Microsoft Office, see the SAS Intelligence Platform: Desktop Application Administration Guide.

Top of Page