Running Data Warehouse Reports in SAS EG

Run standardized Data Warehouse reports of historical BASIS data using SAS Enterprise Guide (EG).

Data Warehouse access is required before running reports, and SAS EG and the ODBC driver must be installed. If you are off campus, you must connect to the campus VPN to access Data Warehouse. 

  1. Open SAS EG.
  2. Click File and select Open
  3. Click SAS Folders. Click Browse.
  4. Double-click the U of A Standardized Reports folder. 
  5. Double-click the category folder that you need. 
  6. Select the report file to open. Click Create Project.
  7. In the Project pane, select the report from the Stored Processes folder. Click Run.
  8. Complete the form. Click Run. 
Print Article

Details

Article ID: 135
Created
Thu 1/11/24 1:40 PM
Modified
Sun 2/25/24 9:28 PM

Related Articles (8)

Installing SAS Add-in for Excel to Use with Data Warehouse
Download and install the SAS Add-in for accessing Data Warehouse with Excel.
Installing SAS EG for Data Warehouse
Download and install SAS Enterprise Guide (EG) for accessing Data Warehouse.
Installing SAS ODBC Driver to Use MS Access with Data Warehouse
The SAS driver for ODBC connects your computer to Data Warehouse reports when using MS Access.
Running Data Warehouse Reports Using MS Access
IT Services recommends using MS Access or SAS EG for accessing BI/Data Warehouse.
Running Data Warehouse Reports Using the SAS Web Application
The SAS Stored Processes Web Application allows access to U of A Standardized Reports to run historical BASIS data reports from Data Warehouse using a web browser.
Running Data Warehouse Reports with Excel
Run standardized Data Warehouse reports of historical BASIS data using the SAS Add-in for Excel. Data Warehouse access is required before running reports, and the SAS Add-in and ODBC driver must be installed.
Running Reports from Data Warehouse
Data Warehouse is a repository made up of over 270 tables of financial (purchasing, payroll, general ledger, etc.), academic (UAConnect) and historical BASIS data copied from live production systems at regular intervals where staff and faculty with appropriate access can run queries and reports of university data.
Troubleshooting Data Warehouse
Troubleshooting tips when using the Data Warehouse

Related Services / Offerings (1)

SAS Data Warehouse
Access and Data modeling for application implementation through the data warehouse.