Me and SASPy (SASPy working with HP-UX sever vs. Windows Client)
This article is to address how to setup SASPy on Windows client to connect to SAS servers installed on UNIX. And, my goal is to utilize the new interface SASPy to facilitate SAS environment adminitration remotely via python.
Before we start, I would like to say that it is a good move to have a interface with python, which is like opening a door to another world. And, it reminds me a picture I saw "Windows Loves Linux", so I draw a similar one just for fun 🙂
In the comming paragraphs, I will introduce the story between me and SASPy (how to setup):
- Install SASPy and dependencies
- Configure SASPy on Windows client
- Examples
- My wish (compatible to python 2.7)
Before installation, you may find a lot of useful information about SASpy from here.
To install SASpy, I installed python 3.6.1 first, and then run the following commands under the command line of my Windows PC,
# pip install pygments
# pip install saspy
# pip install pandasTo install Python, please refer to link.
Next, I need to install SAS Integration Technologies Client, which is used to connect to SAS servers via IOM. You can find it over here, in case of need.
Jupyter Notebook has also been installed to show the examples, you can find the howtos at here.
After installation, it is time to configure SASpy to connect to SAS servers, which is the key point of this article.
How to locate SASpy configuration file sascfg.py:
>> import saspy
>> saspy.SAScfgAbout how to update it, you need to define a configure name first:
SAS_config_names = ['winiomhpux']
Then, build out a local classpath variable to use below for Windows clients:
cpW = "C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94140__prt__xx__sp0__1\\deploywiz\\sas.svc.connection.jar"
cpW += ";C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94140__prt__xx__sp0__1\\deploywiz\\log4j.jar"
cpW += ";C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94140__prt__xx__sp0__1\\deploywiz\\sas.security.sspi.jar"
cpW += ";C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94140__prt__xx__sp0__1\\deploywiz\\sas.core.jar"
cpW += ";C:\\Python36-32\\Lib\\site-packages\\saspy\\java\\saspyiom.jar"
In fact, the jar files can be found under the installation of SAS Integration Technologies Client.
And, the following configuration definitions are for connecting over IOM:
winiomhpux = {'java' : 'C:\\Program Files\\SASHome\\SASPrivateJavaRuntimeEnvironment\\9.4\\jre\\bin\\java',
'iomhost' : '<server name>',
'iomport' : <port # of workspace server>,
'encoding' : '<SAS session encoding>',
'classpath' : cpW,
'omruser' : '<username>',
'omrpw' : '<password>'
}Please note that the user name have to have the relevant permissions to run the examples, e.g. SAS Metadata Server.
So far, you have finished all the configuration.
Now, it's the show time!
Here are some examples to demostrate how it works with python code.
To access sashelp at SAS servers:
To list active users on SAS servers:
Both the 2 examples are running on Windows client. And, you can also put the code input into a file to run it in batch mode.
It is pretty exciting, right?
Finally, it is one of my wish -- I hope SASpy can support python 2.7 for SAS 9.4.
Because my SAS server is SAS 9.4M2, so only python 3+ is supported. And, I can only install python 2.7 on HP-UX somehow.
Generally, I like this function very much. Thanks to the innovation of SAS, it makes that is possible for me to port my python code to work with SAS.
That is it. Hope the story between me and SASpy can give you some inspiration somehow.
