The SAS Add-In for Microsoft Office extends the functionality of Microsoft Excel,
Microsoft Word, Microsoft PowerPoint, and Microsoft Outlook by enabling you to access
SAS analytics and SAS reporting functionality without any SAS programming experience.
The SAS
add-in is designed for users who are familiar with these Microsoft Office applications but
who might be new to SAS.
In general, the functionality of the SAS add-in is the same for Excel, Word, and
PowerPoint. In all of these applications, you can
run analyses, generate reports, and share this SAS content with other users at your
site. Additional functionality is available in Microsoft Excel. For example, in Excel,
you can open and edit data sources.
Note: The functionality
in Microsoft Outlook is unique. Using the native functionality in
Outlook, you can monitor reports and share this information with other
users at your site. However, you cannot create new reports or run
SAS tasks in Outlook. Therefore, the functionality in Outlook is not
covered in this documentation. For more information, see the online
Help for the SAS Add-In for Microsoft Office in Microsoft Outlook.
The SAS add-in includes approximately 80 SAS tasks that enable you to perform a variety
of analyses.
If SAS Studio is installed on the same machine as the SAS Add-In for Microsoft Office
and you are running Internet Explorer 10 (or later), you can also run SAS Studio tasks
by using the SAS add-in. Examples of analyses include linear and nonlinear regressions,
multivariate analyses, time series analyses, one-way frequencies, and summary statistics.
The SAS add-in enables you to refresh these analyses so that your results include
the most up-to-date information. You can also easily share the results with other
users at your site.
Depending on the SAS products that you have installed, you can also open reports or
stored processes that were created in other SAS applications such as SAS Visual Analytics
or
SAS Enterprise Guide. These reports are saved in a common repository, which enables all SAS users at your
site to get the most up-to-date information.
When the SAS add-in is installed on your computer, a SAS tab
is automatically integrated into the Ribbon in Excel, Word, and PowerPoint
2007, 2010, and 2013. The SAS tab enables
you to access the SAS analytics and reporting functionality directly
from these Microsoft Office applications without opening a separate
SAS interface.