Start a SAS session using Jupyter Notebook and SASpy

[luvscandy270]

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. 

[AhmedAl_Attar · Accepted solution]

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'"

[luvscandy270]

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