Installing SAS EG for Data Warehouse

Download and install SAS Enterprise Guide (EG) for accessing Data Warehouse.

Note: This application is available for Windows only. Mac users can access historical BASIS data using the SAS Web Application.

Step 1: Getting Started

If you are off campus, you must connect to the campus VPN to download SAS EG and complete the setup. VPN is also required whenever accessing Data Warehouse from off campus.

Administrative access is required to install this software. For assistance, contact your department tech support.

Step 2: Download SAS EG

1. Map a drive to gizmo using the address:
   \\gizmo\dfs\applications\SAS-BI\SAS94M7
2. Double-click the eg folder, and then double-click setup.exe.
3. 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. 
4. Click OK to Choose Language.
5. Select Install SAS software, and click Next.
6. Confirm that the boxes are checked for SAS Enterprise Guide, SAS Integration Technologies Client, SAS Providers for OLE DB, and SAS/GRAPH ActiveX Control. Click Next.
7. Select 64-bit Native Mode, and click Next.
8. Confirm that the path and filename in the SAS installation data file field is:
   \\gizmo\dfs\applications\SAS-BI\SAS94M7\eg\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.
9. In the Select Language Support window, click Clear All, and click Next.
10. When Checking System is complete, click Next.
11. In Deployment Summary, click Start. When deployment is complete, click Next.
12. In Additional Resources, click Finish.

Step 3: Configure Profile and Options

1. Open SAS Enterprise Guide 8.3.
2. Check for updates by clicking View Details on the blue "An Update is Available" bar at the top. Click Close and Install.
3. Check the "Automatically restart SAS Enterprise Guide" box. Click Finish.
4. When SAS EG reopens, click “No profile selected.”
   Note: If it shows "DW Data" instead of "No profile selected," skip to step 5 if "DW Data" is in the upper right corner instead of No profile selected).
5. Click Add. Enter a Name and Description.
6. Under Server, select Remote. In the Machine field, enter: 
   bireports.uark.edu
7. Check the box to "Save login in profile."
8. Enter your UARK username and password.
9. Click Save and Connect.
10. In the Connections window, click Set Active.
    Note: If this button is grayed out, skip this step.
11. Click Close.
12. In SAS Enterprise Guide, click Tools and select Options.
13. Click Query and uncheck the boxes for “Validate query whenever changes are made” and “Attempt to join tables in query.” Click OK.

Step 4: Run Reports

Running Data Warehouse Reports in SAS EG