What's New

What's New in the SAS Add-In 4.3 for Microsoft Office


The SAS Add-In 4.3 for Microsoft Office is available in Microsoft Excel, Microsoft Word, Microsoft PowerPoint, and Microsoft Outlook. Although some functionality is unique to a specific Microsoft Office application, most functionality is similar in each Microsoft application.

The SAS Add-In 4.3 for Microsoft Office has the following changes and enhancements:

For information about the new features and enhancements in the SAS Add-In 4.2 for Microsoft Office, see What's New in the SAS Add-In 4.2 for Microsoft Office.

Integration with Microsoft Outlook

The SAS Add-In for Microsoft Office is now available in Microsoft Outlook 2010 and Microsoft Outlook 2007. Here are some key features of using the SAS add-in in Microsoft Outlook:

Improvements to the User Interface

In Microsoft Excel, Microsoft Word, and Microsoft PowerPoint 2007, the SAS tab in the Ribbon has been simplified. Additional groups become available depending on the type of SAS content that you select.

When you want to run a task, you are always prompted to select the data source. You are not required to use the selected data source as the input for the task.

Enhancements to the Automation Interface

You can write Visual Basic scripts to automate the functionality in the SAS Add-In for Microsoft Office. Using the automation interface, you can perform the following tasks:

Enhancements to Editing and Viewing Data Sources

Longer Names and Custom Filters for SAS Information Maps

New OLAP Viewer for Working with OLAP Cubes

The new OLAP Viewer enables you to view data that is stored in an OLAP (online analytical processing) cube. Using the OLAP Viewer, you can create table and graph views of your data. You can also drill down through the data, create bookmarks, add calculated measures and calculated members, filter the OLAP data, and view ESRI maps.

Sending and Replicating Results

Specifying Input Streams and Output Parameters for a SAS Stored Process

SAS stored processes are created in SAS applications such as SAS Enterprise Guide or SAS Management Console. If a stored process allows input streams, then you are prompted to select a range of Excel data that will be used as the input data for a stored process. If a stored process contains output parameters, then you are prompted to select which output parameters to include in the results.

New and Enhanced SAS Tasks

New Tasks

Task Enhancements