topic Re: SASPY using pycharm IDE and SAS EG to get the server data in SAS Programming

SASPY using pycharm IDE and SAS EG to get the server data

bikash10 — Wed, 01 Jul 2020 17:13:21 GMT

I am trying to connect the SAS EG with python to get the server data using this code, but I do not have any luck to connect it. We have window client and with IWA.

import pandas
import saspy

winiomIWA = {'java' : 'java',
 'iomhost' : 'server name', --I put my server name in the iomhost
 'iomport' : 8591,
 'sspi' : True
 }

sas=saspy.SASsession(cfgname='winiomIWA)

But I got this error like this "The SAS Config name specified was not found. Please enter the SAS Config you wish to use."

I am a new user for python and just want to connect between the two sources so that I can directly import the data from python to SAS EG.

Thank you,

Bikash

Re: SASPY using pycharm IDE and SAS EG to get the server data

AhmedAl_Attar — Thu, 02 Jul 2020 02:25:25 GMT

Have a look at the documentation here https://sassoftware.github.io/saspy/install.html

Hope this helps,

Ahmed

Re: SASPY using pycharm IDE and SAS EG to get the server data

sastpw — Mon, 13 Jul 2020 17:50:55 GMT

the cfgname= parameter references a configuration definition name in your config file. Your config name you're specifying is a local variable in your python environment, which is why you're getting that error. The instructions here (https://sassoftware.github.io/saspy/install.html#configuration) explain to create a config file, sascfg_personal.py, with that config definition you've put together so that it will be used to connect.

The example config file, in the repo (sascfg.py) contains examples of many various configuration definitions anyone might need, depending upon what type of SAS deployment they are trying to connect to.

For your config below, you can create your config file with it, and you would then need this line in there too:

SAS_config_names=['winiomIWA']

So, your sascfg_persional.py config file could simply be:

SAS_config_names=['winiomIWA']

winiomIWA = {'java' : 'java',
 'iomhost' : 'server name', # Do put your server name in the iomhost
 'iomport' : 8591,
 'sspi' : True
 }