Hi , We currently have a SAS 9.4 Grid system on a linux machine. we are trying to use SASPY python module in the local windows machine connecting to the sasgrid. How can we achieve this. we have our python3.7 , pandas, saspy modules installed in our local windows machine, also the sascfg.py is modified as follows SAS_config_names=['default', 'iomlinux', 'winiomlinux', 'ssh'] SAS_config_options = {'lock_down': False, 'verbose' : True } SAS_output_options = {'output' : 'html5'} default = {'saspath' : '/sascommon/SAS/SASHome/SASFoundation/9.4/bin/sas_u8' } ssh = {'saspath' : '/sascommon/SAS/SASHome/SASFoundation/9.4/bin/sas_en', 'ssh' : '/usr/bin/ssh', 'host' : 'sesklsasgrndevxx.emea.xx.net', 'encoding': 'latin1', 'options' : ["-fullstimer"] } # build out a local classpath variable to use below for Linux clients CHANGE THE PATHS TO BE CORRECT FOR YOUR INSTALLATION cpL = "/sascommon/SAS/SASHome/SASDeploymentManager/9.4/products/deploywiz__94500__prt__xx__sp0__1/deploywiz/sas.svc.connection.jar" cpL += ":/sascommon/SAS/SASHome/SASDeploymentManager/9.4/products/deploywiz__94500__prt__xx__sp0__1/deploywiz/log4j.jar" cpL += ":/sascommon/SAS/SASHome/SASDeploymentManager/9.4/products/deploywiz__94500__prt__xx__sp0__1/deploywiz/sas.security.sspi.jar" cpL += ":/sascommon/SAS/SASHome/SASDeploymentManager/9.4/products/deploywiz__94500__prt__xx__sp0__1/deploywiz/sas.core.jar" cpL += ":/opt/github/saspy/java/saspyiom.jar" iomlinux = {'java' : '/usr/bin/java', 'iomhost' : 'sesklsasgrndevxx.emea.xx.net', 'iomport' : 8591, 'encoding' : 'latin1', 'classpath' : cpL } iomwin = {'java' : '/usr/bin/java', 'iomhost' : 'windows.iom.host', 'iomport' : 8591, 'encoding' : 'windows-1252', 'classpath' : cpL } # build out a local classpath variable to use below for Windows clients CHANGE THE PATHS TO BE CORRECT FOR YOUR INSTALLATION cpW = "C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94472__prt__xx__sp0__1\\deploywiz\\sas.svc.connection.jar" cpW += ";C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94472__prt__xx__sp0__1\\deploywiz\\log4j.jar" cpW += ";C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94472__prt__xx__sp0__1\\deploywiz\\sas.security.sspi.jar" cpW += ";C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94472__prt__xx__sp0__1\\deploywiz\\sas.core.jar" cpW += ";C:\\ProgramData\\Anaconda3\\Lib\\site-packages\\saspy\\java\\saspyiom.jar" # These jars provide CORBA support for Java 10+ which no longer provides CORBA itself. CHANGE THE PATHS TO BE CORRECT FOR YOUR INSTALLATION cpW += ";C:\\ProgramData\\Anaconda3\\Lib\\site-packages\\saspy\\java\\thirdparty\\glassfish-corba-internal-api.jar" cpW += ";C:\\ProgramData\\Anaconda3\\Lib\\site-packages\\saspy\\java\\thirdparty\\glassfish-corba-omgapi.jar" cpW += ";C:\\ProgramData\\Anaconda3\\Lib\\site-packages\\saspy\\java\\thirdparty\\glassfish-corba-orb.jar" cpW += ";C:\\ProgramData\\Anaconda3\\Lib\\site-packages\\saspy\\java\\thirdparty\\pfl-basic.jar" cpW += ";C:\\ProgramData\\Anaconda3\\Lib\\site-packages\\saspy\\java\\thirdparty\\pfl-tf.jar" # And, if you've configured IOM to use Encryption, you need these client side jars. CHANGE THE PATHS TO BE CORRECT FOR YOUR INSTALLATION #cpW += ";C:\\Program Files\\SASHome\\SASVersionedJarRepository\\eclipse\\plugins\\sas.rutil_904300.0.0.20150204190000_v940m3\\sas.rutil.jar" #cpW += ";C:\\Program Files\\SASHome\\SASVersionedJarRepository\\eclipse\\plugins\\sas.rutil.nls_904300.0.0.20150204190000_v940m3\\sas.rutil.nls.jar" #cpW += ";C:\\Program Files\\SASHome\\SASVersionedJarRepository\\eclipse\\plugins\\sastpj.rutil_6.1.0.0_SAS_20121211183517\\sastpj.rutil.jar" winlocal = {'java' : 'java', 'encoding' : 'windows-1252', 'classpath' : cpW } winiomlinux = {'java' : 'java', 'iomhost' : 'sesklsasgrndev01.emea.astrazeneca.net', 'iomport' : 8591, 'encoding' : 'latin1', 'classpath' : cpW } winiomwin = {'java' : 'java', 'iomhost' : 'windows.iom.host', 'iomport' : 8591, 'encoding' : 'windows-1252', 'classpath' : cpW } winiomIWA = {'java' : 'java', 'iomhost' : 'windows.iom.host', 'iomport' : 8591, 'encoding' : 'windows-1252', 'classpath' : cpW, 'sspi' : True } iomcom = { 'iomhost': 'mynode.mycompany.org', 'iomport': 8591, 'class_id': '440196d4-90f0-11d0-9f41-00a024bb830c', 'provider': 'sas.iomprovider', 'encoding': 'windows-1252'} httpsviya = {'ip' : 'sastpw.rndk8s.openstack.sas.com', 'context' : 'Data Mining compute context', 'authkey' : 'viya_user-pw', 'options' : ["fullstimer", "memsize=1G"] } httpviya = {'ip' : 'sastpw.rndk8s.openstack.sas.com', 'ssl' : False, # this will use port 80 'context' : 'Data Mining compute context', 'authkey' : 'viya_user-pw', 'options' : ["fullstimer", "memsize=1G"] }
... View more