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 dashboards 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. 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.
Using the SAS add-in,
you can also open reports or stored processes that were created in
other SAS applications, such as SAS Enterprise Guide, SAS Web Report
Studio, or SAS Visual Analytics. 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.