Skip to content

Instantly share code, notes, and snippets.

@kishdubey
Created September 5, 2019 02:37
Show Gist options
  • Save kishdubey/d85db71ea1683a8188fc15ff7d5df80d to your computer and use it in GitHub Desktop.
Save kishdubey/d85db71ea1683a8188fc15ff7d5df80d to your computer and use it in GitHub Desktop.
configure local connection in saspy
saspy provides Python APIs to the SAS environment.
Configuring SASPy on Windows 7:
1. Create a python file by the name of "sascfg_personal.py" at C:\\Program Files\\Anaconda3\\lib\\site-packages\\saspy
2. Fill file with following:
SAS_config_names = ['winlocal']
# Windows client class path
# build out a local classpath variable to use below for Linux clients CHANGE THE PATHS TO BE CORRECT FOR YOUR INSTALLATION
cpW = "C:\Program Files\SASHome\SASDeploymentManager\9.4\products\deploywiz__94435__prt__xx__sp0__1\deploywiz\sas.svc.connection.jar"
cpW += ";C:\Program Files\SASHome\SASDeploymentManager\9.4\products\deploywiz__94435__prt__xx__sp0__1\deploywiz\log4j.jar"
cpW += ";C:\Program Files\SASHome\SASDeploymentManager\9.4\products\deploywiz__94435__prt__xx__sp0__1\deploywiz\sas.security.sspi.jar"
cpW += ";C:\Program Files\SASHome\SASDeploymentManager\9.4\products\deploywiz__94435__prt__xx__sp0__1\deploywiz\sas.core.jar"
cpW += ";C:\Program Files\Anaconda3\Lib\site-packages\saspy\java\saspyiom.jar"
# Windows client and Local Windows IOM server
winlocal = {'java' : 'java',
'encoding' : 'windows-1252',
'classpath' : cpW
}
3. Create system PATH variable, insert 'C:\Program Files\SASHome\SASFoundation\9.4\core\sasext'
4. Change Java version from 1.8 to 1.7
a. go to HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Runtime Environment
b. change value CurrentVersion from '1.8' to '1.7'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment