Start a SAS session using Jupyter Notebook and SASpy

luvscandy270 — Sat, 05 Oct 2024 15:28:29 GMT

Hello Everyone,

I have been trying for sometime to start a SAS session using saspy in Jupyter Notebook. I have went through all troubleshooting and looked at questions posted by others but still I am unable to start a SAS session. Any help would be greatly appreciated.

I created my sascfg_personal.py file as follows:

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

Next, I created the _authoinfo file (made sure .txt was removed):

oda user myusername password mypassword

Finally, I ran the following code in jupyter notebook:

sas_session = saspy.SASsession()
sas_session

And I receive the following message:

Using SAS Config named: oda
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.


I'm thinking something maybe incorrect in my sascfg_personal.py file but I'm not sure what it is, any help would be greatly appreciated.

Re: Start a SAS session using Jupyter Notebook and SASpy

AhmedAl_Attar — Sat, 05 Oct 2024 17:19:48 GMT

Hi @luvscandy270

Just to double check, do you have Java installed on your machine in the location you are specifying in the SASpy configuration file?

"'java' : 'C:\\Program Files (x86)\\Common Files\\Oracle\\Java\\javapath\\java.exe'"

Re: Start a SAS session using Jupyter Notebook and SASpy

luvscandy270 — Sat, 05 Oct 2024 21:10:36 GMT

Thank you so much!!! That was my issue!!

topic Start a SAS session using Jupyter Notebook and SASpy in SAS Data Science

Start a SAS session using Jupyter Notebook and SASpy

Re: Start a SAS session using Jupyter Notebook and SASpy

Re: Start a SAS session using Jupyter Notebook and SASpy