Install SAS Add-in for Excel
Download and install the SAS Add-in for accessing Data Warehouse with Excel.
Note: This application is available for Windows only. Mac users can access historical BASIS data using the SAS Web Application.
Step 1: Getting Started
Follow these steps before downloading and installing the SAS Add-in for Excel.
- If you are off campus, you must connect to the campus VPN to download the add-in and complete the setup. VPN is also required whenever accessing Data Warehouse from off campus.
- Close all Microsoft Office applications, including Excel, before continuing.
Heads up! Administrative access is required to install this software. For assistance, contact your department tech support.
Step 2: Download SAS Add-in
-
Map a drive to gizmo (or use previously mapped drive) using the address:
\\gizmo\dfs\applications\SAS-BI\SAS94M7 - Double-click the AddIns folder, and then double-click setup.exe.
- Click Yes to allow SDW Bootstrap in d4deploy to make changes to the device. If required to log in, use your full UARK email address and password.
- Click OK to Choose Language.
- Select Install SAS software, and then click Next. Check the box for SAS Add-in for Microsoft Office, and then click Next.
- Confirm that the path and filename in the SAS installation data file field is:
\\gizmo\dfs\applications\SAS-BI\SAS94M7\AddIns\sid_files\SAS94_9CKJRM_70206997_Win_X64_Wrkstn.txt
Note: You might have to click in the SAS installation data file field and select this path from the dropdown. - Click Next.
- In Select Language Support, click Clear All. Click Next.
- In Select Microsoft Office Applications, check the box for Microsoft Excel and uncheck all other boxes. Click Next.
- When Checking System is complete, click Next.
- In Deployment Summary, click Start. When Deployment is complete, click Next.
- In Additional Resources, click Finish.
Step 3: Set Up SAS Add-in with Excel
- Open Excel. In the SAS Update pop-up window, click Close and Install.
- Click Yes to allow SDW Bootstrap in d4deploy to make changes to the device. If required to log in, use your full UARK email address and password.
- In the SAS Add-in window, click Finish.
- In Excel, select Blank Workbook.
- From the SAS ribbon, click the Tools button, and then click Options.
- In the Change Office option for multiple displays pop-up, check the box "Don’t show this message again," and click Yes.
- In the Results section of Options, check the box for “Automatically insert results into the Office document when opening a report,” and uncheck the box for “Allow Excel to interpret value types in SAS Report tables”. Click OK.
- Click the Tools button on the SAS ribbon. Click Connections, and then click the Manage button.
- Click Add. Enter a Name and Description.
- Under Server, select Remote. In the Machine field, enter:
bireports.uark.edu - Check the box to "Save login in profile."
- Enter your UARK username and password.
- Click Save and Connect.
- In the Connections window, click Set Active.
Note: If this button is grayed out, skip this step. - Click Close.