Introduction
The SAS Add-in for Microsoft Office is software that provides a secure, personalized and efficient connection between SAS Analytics and Microsoft Office products. It enables users to efficiently access, visualize and manipulate SAS datasets in Microsoft Office applications. This document covers the steps involved in installing and using the SAS Add-in for Microsoft Office.
How to Install the SAS Add-in for Microsoft Office
The SAS Add-in for Microsoft Office is available as a free download from the SAS Support website. Follow these steps to install the Add-in.
- Download the SAS Add-in from the [SAS Support website]
- Run the downloaded installer.
- Select the components to be installed.
- Click Install.
- Accept the license and follow the on-screen instructions to complete the installation.
How to Use the SAS Add-in for Microsoft Office
Once the Add-in is installed, users can access SAS datasets in Microsoft Office applications. Here’s how:
- In MS Office applications such as Word, Excel, and Power Point, select the ‘SAS’ tab and click ‘Connect to SAS’.
- Enter your SAS login credentials in the login window and click ‘Login’.
- From the left pane, select the data set you would like to use.
- Review the data and click ‘OK’ to import it into MS Office.
- Use the MS Office application to visualize and manipulate SAS datasets.
FAQ
What is the SAS Add-in for Microsoft Office?
The SAS Add-in for Microsoft Office is software that provides a secure, personalized and efficient connection between SAS Analytics and Microsoft Office products. It enables users to efficiently access, visualize and manipulate SAS datasets in Microsoft Office applications.
What versions of Microsoft Office are supported?
The SAS Add-in for Microsoft Office supports the following versions of Microsoft Office: Office 2016, Office 2013, and Office 2010.
Do I need to pay for the SAS Add-in?
No, the SAS Add-in for Microsoft Office is a free download available from the SAS Support website.
Can I use the SAS Add-in for Macs?
Yes, the SAS Add-in for Microsoft Office is supported on both Windows and Mac platforms.
How secure is the connection between SAS Analytics and Microsoft Office?
The SAS Add-in for Microsoft Office uses the secure OData protocol to ensure that all data is kept secure and encrypted as it is transferred from SAS Analytics to Microsoft Office products.