SAS Add-In for Microsoft Office (Excel) - Exchanging Data Between SAS and Microsoft Excel - page 93

Figure 7.2: Microsoft Excel with the SAS Tab on the Ribbon for the SAS Add-In for
Microsoft Office.

Table 7.2 shows the features available on the SAS tab for Microsoft Excel, but the other Microsoft products
(Word, PowerPoint, and Outlook) all have different sets of features available. Microsoft Excel is the only
Microsoft product that can open a data source. A data source is either a SAS dataset or an OLAP cube.

NOTE: The features described here do not require the activation of SAS Business Intelligence software,
but do require a license for SAS Business Intelligence software.

Table 7.2: SAS Add-In for Microsoft Office (Excel) Tab Options.
Group Option Function

Insert SAS Data Opens a SAS data source.

Tasks Performs one of over 75 options including sorting,

transposing, and graphing.

Reports Allows searching the network and executing available

*.srx report routines.

Quick Start Allows for the selection of multiple graphing tasks,

automatic charts, and statistical processes.

SAS Favorites Allows storing and executing favorite report routines in

a profile file.

Selection Refresh ** Re-runs an analysis.

Modify ** Changes any optional parameters available to the task.

Properties** Allows review and changing of report properties.

Tools Manage Content** Allows changing optional parameters and running

selected reports.

Tools Contains several features for managing data, reports,

styles, and scheduling reports.

Help Contains Help information for SAS Add-In for

Microsoft Office.

** Available after a report is executed.