topic Re: Unable to start a SASsession in Administration and Deployment

Unable to start a SASsession

Santt0sh — Wed, 07 Apr 2021 00:01:38 GMT

Hi All,
 
I am learning to use Python/Jupyter Notebook, I have followed all steps provided in the support doc but i'm still unable to start a SASsession.
Can any of the SAS experts help fix this Syntax error(SyntaxError: invalid syntax)? 
 
import saspy
sas_session = saspy.SASsession()
sas_session
 
 
Please find the error below after i import the saspy and start a SASsession.

Traceback (most recent call last):

  File "C:\ProgramData\Anaconda3\lib\site-packages\IPython\core\interactiveshell.py", line 3418, in run_code
    exec(code_obj, self.user_global_ns, self.user_ns)

  File "<ipython-input-20-0483c802e9d9>", line 2, in <module>
    sas_session = saspy.SASsession()

  File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 465, in __init__
    self.sascfg            = SASconfig(**kwargs)

  File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 129, in __init__
    SAScfg = self._find_config(cfg_override=kwargs.get('cfgfile'))

  File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 332, in _find_config
    import sascfg_personal as SAScfg

  File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sascfg_personal.py", line 6
    'iomhost' :['odaws01-usw2.oda.sas.com','odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com']
    ^
SyntaxError: invalid syntax

Re: Unable to start a SASsession

Sajid01 — Wed, 07 Apr 2021 00:54:00 GMT

Can we have the output of the following.

import saspy
sas_session = saspy.SASsession()
I hope you are using SAS studio.
If not what is your setup / environment.

Re: Unable to start a SASsession

Santt0sh — Wed, 07 Apr 2021 01:33:45 GMT

Thanks for your quick response, yes i am using SAS Studio.
import saspy
sas_session = saspy.SASsession()
Please find the output below.
==========================================
Traceback (most recent call last):

File "C:\ProgramData\Anaconda3\lib\site-packages\IPython\core\interactiveshell.py", line 3418, in run_code
exec(code_obj, self.user_global_ns, self.user_ns)

File "<ipython-input-2-6370c5ed4af2>", line 2, in <module>
sas_session = saspy.SASsession()

File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 465, in __init__
self.sascfg = SASconfig(**kwargs)

File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 129, in __init__
SAScfg = self._find_config(cfg_override=kwargs.get('cfgfile'))

File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 332, in _find_config
import sascfg_personal as SAScfg

File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sascfg_personal.py", line 6
'iomhost' :['odaws01-usw2.oda.sas.com','odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com']
^
SyntaxError: invalid syntax

Re: Unable to start a SASsession

gwootton — Wed, 07 Apr 2021 14:14:41 GMT

It looks like the problem is with your sascfg_personal.py file's syntax for that iomhost option. The example in the default sascfg.py is:

iomlinux = {'java' : '/usr/bin/java',
'iomhost' : 'linux.iom.host',
'iomport' : 8591,
}

Re: Unable to start a SASsession

Santt0sh — Wed, 07 Apr 2021 16:18:20 GMT

Hi Greg,

Thanks for your reply,

This is my sascfg_personal.py and the error is for a particular line.
'iomhost' :['odaws01-usw2.oda.sas.com','odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com']

Kindly Suggest!!
====================================================
SAS_config_names=['oda']
oda = {'java' : 'C:\\Program Files (x86)\\Common Files\\Oracle\\Java\\javapath\\java.exe',
#US Home Region
US
#'iomhost' : ['odaws01-usw2.oda.sas.com','odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com'],
'iomhost' :['odaws01-usw2.oda.sas.com','odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com']
#European Home Region
#'iomhost' : ['odaws01-euw1.oda.sas.com','odaws02-euw1.oda.sas.com'],
#Asia Pacific Home Region
#'iomhost' : ['odaws01-apse1.oda.sas.com','odaws02-apse1.oda.sas.com'],
'iomport' : 8591,
'authkey' : 'oda',
'encoding' : 'utf-8'
}

Re: Unable to start a SASsession

gwootton — Wed, 07 Apr 2021 16:23:21 GMT

Should "US" be commented out there?

Also, should there be a comma at the end of your uncommented iomhost line?

Re: Unable to start a SASsession

gwootton — Wed, 07 Apr 2021 16:27:52 GMT

Another thought would be separating your different hosts into different configs:

SAS_config_names=['oda','usr','eur','apr']
oda = {'java' : 'C:\\Program Files (x86)\\Common Files\\Oracle\\Java\\javapath\\java.exe',
#US Home Region
'iomhost' :['odaws01-usw2.oda.sas.com','odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com'],
#European Home Region
#'iomhost' : ['odaws01-euw1.oda.sas.com','odaws02-euw1.oda.sas.com'],
#Asia Pacific Home Region
#'iomhost' : ['odaws01-apse1.oda.sas.com','odaws02-apse1.oda.sas.com'],
'iomport' : 8591,
'authkey' : 'oda',
'encoding' : 'utf-8'
}
usr = {'java' : 'C:\\Program Files (x86)\\Common Files\\Oracle\\Java\\javapath\\java.exe',
'iomhost' :['odaws01-usw2.oda.sas.com','odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com'],
'iomport' : 8591,
'authkey' : 'oda',
'encoding' : 'utf-8'
}
eur = {'java' : 'C:\\Program Files (x86)\\Common Files\\Oracle\\Java\\javapath\\java.exe',
'iomhost' : ['odaws01-euw1.oda.sas.com','odaws02-euw1.oda.sas.com'],
'iomport' : 8591,
'authkey' : 'oda',
'encoding' : 'utf-8'
}
apr = {'java' : 'C:\\Program Files (x86)\\Common Files\\Oracle\\Java\\javapath\\java.exe',
'iomhost' : ['odaws01-apse1.oda.sas.com','odaws02-apse1.oda.sas.com'],
'iomport' : 8591,
'authkey' : 'oda',
'encoding' : 'utf-8'
}

Re: Unable to start a SASsession

Santt0sh — Wed, 07 Apr 2021 16:48:27 GMT

Hi Greg,

yes you were correct US should be Commented and after i commented i ma getting a new error. i m trying to resolve this error, Please suggest me on this .
Thanks.
=======================================
Traceback (most recent call last):

File "C:\ProgramData\Anaconda3\lib\site-packages\IPython\core\interactiveshell.py", line 3418, in run_code
exec(code_obj, self.user_global_ns, self.user_ns)

File "<ipython-input-3-6370c5ed4af2>", line 2, in <module>
sas_session = saspy.SASsession()

File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 465, in __init__
self.sascfg = SASconfig(**kwargs)

File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 129, in __init__
SAScfg = self._find_config(cfg_override=kwargs.get('cfgfile'))

File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py", line 332, in _find_config
import sascfg_personal as SAScfg

File "C:\ProgramData\Anaconda3\lib\site-packages\saspy\sascfg_personal.py", line 10
'iomport' : 8591,
^
SyntaxError: invalid syntax

Re: Unable to start a SASsession

gwootton — Wed, 07 Apr 2021 16:49:42 GMT

Did you also add the comma to the end of the iomhost line?

Re: Unable to start a SASsession

Santt0sh — Wed, 07 Apr 2021 18:41:10 GMT

Hi George,

No, I haven't added the comma at the end of the IOM line.

Re: Unable to start a SASsession

gwootton — Wed, 07 Apr 2021 18:48:54 GMT

Let us know if doing so resolves the new error.

Re: Unable to start a SASsession

Santt0sh — Wed, 07 Apr 2021 19:15:20 GMT

Hi Greg,
Nothing has changed even after add or removing the comma.
---------------------------------------------------------------------------
KeyError Traceback (most recent call last)
<ipython-input-4-99201ba30faf> in <module>
1 import saspy
----> 2 sas_session = saspy.SASsession()
3 cars=sas.sasdata('cars', 'sashelp')
4 cars.head()

C:\ProgramData\Anaconda3\lib\site-packages\saspy\sasbase.py in __init__(self, **kwargs)
535 if self.sascfg.mode != 'HTTP':
536 try:
--> 537 self.pyenc = sas_encoding_mapping[self.sascei]
538 except KeyError:
539 print("Invalid response from SAS on inital submission. printing the SASLOG as diagnostic")

KeyError: 'No SAS process attached. SAS process has terminated unexpectedly.'

Re: Unable to start a SASsession

gwootton — Wed, 07 Apr 2021 19:40:36 GMT

It looks like you are no longer encountering the syntax error...
Try this:

import saspy
from IPython.display import HTML
sas = saspy.SASsession(cfgname="oda")
c = sas.submit("""
proc setinit; run;
""")
c = sas.submit("""
proc setinit;
run;
""")
HTML(c['LOG'])

Re: Unable to start a SASsession

gwootton — Wed, 07 Apr 2021 19:55:10 GMT

I was able to get your code to work by changing

cars=sas.sasdata('cars', 'sashelp')

cars=sas_session.sasdata('cars', 'sashelp')

Re: Unable to start a SASsession

Santt0sh — Wed, 07 Apr 2021 20:03:11 GMT

Hi Greg,
Yes now i am not getting Syntax error,
after i tried running the code.

Error trying to read authinfo file:C:\Users\santo\_authinfo
[Errno 13] Permission denied: 'C:\\Users\\santo\\_authinfo'
Did not find key oda in authinfo file:C:\Users\santo\_authinfo

Please enter the IOM user id: psantosh0
The OS Error was:
The system cannot find the file specified
==============================================================
Error trying to read authinfo file:C:\Users\santo\_authinfo
[Errno 13] Permission denied: 'C:\\Users\\santo\\_authinfo'
Did not find key oda in authinfo file:C:\Users\santo\_authinfo

Please enter the IOM user id: psantosh0
The OS Error was:
The system cannot find the file specified

SAS Connection failed. No connection established. Double check your settings in sascfg_personal.py file.

Re: Unable to start a SASsession

Santt0sh — Wed, 07 Apr 2021 20:05:42 GMT

Hi Greg,
Error trying to read authinfo file:C:\Users\santo\_authinfo
[Errno 13] Permission denied: 'C:\\Users\\santo\\_authinfo'
Did not find key oda in authinfo file:C:\Users\santo\_authinfo

Permissions for all the users on this folder are granted.

Re: Unable to start a SASsession

gwootton — Wed, 07 Apr 2021 20:09:23 GMT

You may want to try removing the authkey option from your sascfg_personal.py.

That message seems to indicate you do not have the necessary permissions to read that file.
Does the file exist and have permissions set as outlined in https://go.documentation.sas.com/api/docsets/authinfo/9.4/content/authinfo.pdf
For the server name, have you specified the value in your authkey option?

Re: Unable to start a SASsession

Santt0sh — Wed, 07 Apr 2021 20:33:06 GMT

Hi Greg,

Thanks for the link, i am going through it now. I have a simple question
What should be the extension or format the auth file. Now my auth file is in _authinfo.py Should the authfile have the extension ".netrc"?

Re: Unable to start a SASsession

gwootton — Wed, 07 Apr 2021 20:54:18 GMT

Typically the authinfo file has no extension. In Windows the file is called "_authinfo" and in UNIX ".authinfo".