How to Use the SAS Add-In for Microsoft Office

In Microsoft Office 2010 and Microsoft Office 2007, the SAS add-in is available from the SAS tab in the Ribbon. You access the SAS add-in from the menu options on this tab.

Note: If you do not see a SAS tab, then you might not have the SAS add-in installed. For help, contact the SAS support personnel at your site.

You can perform a variety of tasks using the SAS add-in. The following process briefly explains how you would run a SAS analysis:

Open Microsoft Excel, Word, or PowerPoint.
Select the analysis that you want to perform.

Note: After you select the analysis, you might be prompted to log on to the SAS server. You must be connected to a SAS server to run an analysis or to access a SAS data source.
Select the data source that you want to use in the analysis. In Excel, you can use data in an existing Excel worksheet or in a SAS data source. If you select a SAS data source, you can filter and sort the data before the analysis.
Select the options in the analysis that you want to use, and then run the analysis.
Specify the location of the output. For example, in Excel, you can include the results in the existing worksheet, in a new worksheet, or in a new workbook.

The results open in the Microsoft Office document.