October 10, 2023
This document offers some tips on working with SAS 9.4M6 in the Analytics Enclave environment. For in-depth knowledge or deeper understanding of SAS, please visit: https://support.sas.com/en/documentation.html
- You should have a SAS license. For more information, visit the Research Information Science & Computing (RISC) websites, https://rc.partners.org/ (Academic Software License Core Offerings) and Request a new SAS license. To purchase the SAS license, visit https://rcservices.partners.org.
- Access to Enclave should already be approved and granted. If you do not have approval to access the Enclave, complete and submit the Access Request Form.
SAS 9.4M6 Server Application and SAS Programs
- SAS 9.4M6 is available in the Enclave - Base SAS 9.4M6, SAS Enterprise Guide 8.2 (64 bit) & SAS Studio.
- The SAS Work directory is in the H: drive. SAS datasets and temporary files are stored in the H: drive where there is sufficient space for the SAS programs to run optimally.
- Log in to your Analytics Enclave workspace. If you are a new user, then please review the document HOWTO: Get Started With The Analytics Enclave for instructions. You can connect to your Enclave Virtual Desktop in 2 ways:
- Using the VMware Horizon Client
- Via a supported web browser (HTML Access).
- Upon successful log in to the VDI Desktop, you will see the SAS application icons as shown below.
Base SAS 9.4 - Click on the shortcut icons to open the application. Remember to save your work and log out on completion of your work.
SAS Enterprise Guide 8.2 - Click on the shortcut icons to open the application. Remember to save your work and log out on completion of your work.
SAS Studio 3.8 - Click on the shortcut icons to open the application. Remember to save your work and log out on completion of your work.
SAS Test Program
You may execute the test and example SAS programs provided in BASE SAS or SAS Enterprise Guide 8.2 or SAS Studio to test out the SAS applications and SAS JDBC Driver connection to the Microsoft SQL Servers.
data test; set sashelp.class; run; Proc print data=test; run;
Connecting to the SQL Server databases
Example I: Access I2B2 dbo.OBSERVATION_FACT Table
options FULLSTIMER noquotelenmax; proc fedsql nolibs conn="DRIVER=JDBC; CLASSPATH='C:\Program Files\sqljdbc_8.2\enu\mssql-jdbc-8.2.2.jre8.jar'; CLASS='com.microsoft.sqlserver.jdbc.SQLServerDriver'; URI='jdbc:sqlserver://mgbsql0008.partners.org:1433;databaseName=i2b2;domain=partners.org;IntegratedSecurity=true;'; schema=dbo; CATALOG=jdbc"; select * from dbo.OBSERVATION_FACT where NVAL_NUM >= 50; QUIT;