Hi
We are using SAS(9.4) in remote linux server and we need to connect the SAS app to the databricks. I've installed saspy in the cluster.
the config setting is here
config = ''' SAS_config_names=['l****ty'] loyalty = {'java' : '/usr/bin/java', 'iomhost' : 'lnzlwl*****.lnzl.co.nz', 'iomport' : 18**2, 'authkey' : 'l****ty', 'encoding' : 'latin1' } '''
I got this error:
The application could not log on to the server "lnzl********.lnzl.co.nz:18**2". The machine name is not valid.
I am sure about the host and port since I copied from SAS app
Please advise
Thanks
What SAS/ACCESS product are you using to connect to Databricks? SAS/ACCESS to Databricks / ODBC / JDBC? Have you configured the ACCESS product to work with Databricks?
I am using saspy package to do this connection and do this setting, set the config as above and then run this command:
sas = saspy.SASsession()
got this error:
Using SAS Config named: loyalty We failed in getConnection The application could not log on to the server "lnzlwlgs****01.lnzl.co.nz:18592". The machine name is not valid. SAS process has terminated unexpectedly. Pid State= (1780, 64000) SAS Connection failed. No connection established. Double check your settings in sascfg_personal.py file.
The only trouble shooting advice I can give is try to ping the server from the instance this configuration file is being used.
Other than that, try SAS tech support.
It feels like a SAS/ACCESS to ODBC would be easier to setup. But maybe you prefer working with notebooks, even if it's SAS code (or I may misunderstood how this is working)?
Yes, we need to connect to SAS by notebook.
I've tried to change my configuration and used IP address of server, the type of error is changed, before it said the machine name is incorrect now it said the port is incorrect, could you help me to find how I can find SAS is using which port?
config = ''' SAS_config_names=['loyalty'] loyalty = {'java' : '/usr/bin/java', 'autoexec' : 'options filesystem=hfs;', 'iomhost' : '192.168.**.176', 'iomport' : 8591, 'authkey' : 'loyalty', 'appserver' : 'lnzlwlgs****01.lnzl.co.nz' } '''
AFAIK, SASPy provides an interface between Python and SAS. When you run Python code in SASPy it is converted into SAS code that runs in your SAS installation. I don't see how this could possibly work with Databricks unless you had a SAS product (like SAS/ACCESS) able to do this, unless I'm completely misunderstanding what's possible.
Did you figure out your host and port? Also, you had the `appserver` key in your posted config, with an invalid value. It's not clear you need that, but specifying it with an invalid value will cause a problem. Not seeing the actual errors or output from what you're trying doesn't help. Can you show the code you're submitting and all of the output? Do you still need help with this? Or did you get it working?
Tom
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: