topic Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook. in SAS Viya

Query Regarding SAS Kernel connection through https method in Jupyter notebook.

navdeepk — Thu, 12 Sep 2024 11:21:46 GMT

I am having trouble connecting sas_kernel in jupyter to SAS viya. I am currently on a free trial , I found the below spec which needs to be changed in order ti connect with SAS viya.

httpsviya = {'url' : 'https://viya.deployment.com',
'context' : 'SAS Studio compute context',
'authkey' : 'viya_user-pw',
'options' : ["fullstimer", "memsize=1G"]
}

But I am not sure on where to find and what to fill in them. Any help?

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

AhmedAl_Attar — Thu, 12 Sep 2024 14:19:31 GMT

Hi @navdeepk

Check out the SASPy configuration SASPy configuration for how to set this up

Hope this helps,

Ahmed

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

navdeepk — Thu, 12 Sep 2024 14:24:10 GMT

Hi Ahmed, I did check it out as i mentioned
httpsviya = {'url' : 'https://viya.deployment.com',
'context' : 'SAS Studio compute context',
'authkey' : 'viya_user-pw',
'options' : ["fullstimer", "memsize=1G"]
}
This is what needs to be filled as per my understanding. But i am not sure on where to find for those values. Like what would the auth key be and the url be.

Ps: I am using the free trial of sas viya on web.

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

AhmedAl_Attar — Thu, 12 Sep 2024 15:21:38 GMT

@navdeepk

Just clarify this for me

1. When you said "Ps: I am using the free trial of sas viya on web", doesn't that imply you have a URL to access viya!?

if so, then that would be the value for the url: key

2. the SASPy configuration link I sent you, has the following

The .authinfo file (_authinfo on Windows)¶
The IOM and HTTP access methods have support for getting the required user/password 
from an authinfo file in the user’s home directory instead of prompting for it. 
On linux, the file is named .authinfo and on windows, it’s _authinfo. The format of 
the line in the authinfo file is as follows. The first value is the authkey value 
you specify for authkey. Next is the ‘user’ key followed by the value (the user id) 
and then ‘password’ key followed by its value (the user’s password). 
Note that there are permission rules for this file. On linux the file must have 
permissions of 600, only the user can read or write the file. On Windows, the file 
should be equally locked down to where only the owner can read and write it. 
Also, the encoding of this file should be UTF-8, or any encoding that has ASCII 
as it’s low order 7-bits if you only use those characters in the file. 
It’s read into Python as is, and thus is expected to be utf-8.

So, wherever (Windows | Linux) you are launching Jupyter from, place/create the _authinfo | .authinfo file in your home (C:\Users\<YourID> | /home/<YourID> ) directory, with the following contents

authkey user <viya_user_id> password <viya_user_password>

Hope this helps

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

navdeepk — Fri, 13 Sep 2024 11:35:41 GMT

I have tried it, I am getting the below error

SASHTTPauthenticateError: Failure in GET AuthToken.
Failure in GET AuthToken. Status=401
Response=b'{"error":"unauthorized","error_description":"Bad credentials"}'

Is the userId and userpassword same as the email and password I use to login to sasviya app? Or Is it something else, if yes could you tell me where to find them.

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

AhmedAl_Attar — Fri, 13 Sep 2024 12:38:33 GMT

@navdeepk

"Is the userId and userpassword same as the email and password I use to login to sasviya app?"
Yes, it should be.

Please ensure the credentials (username/password) you have used in the .authinfo|_authinfo file, are correct and you can successfully login into SAS Viya when using the Viya Web Login page from your browser.

@sastpw are we missing anything else here?

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

navdeepk — Fri, 13 Sep 2024 12:54:15 GMT

https://imgur.com/a/W8Ojemg
I did try with my credentials, its not working.

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

sastpw — Fri, 13 Sep 2024 13:18:58 GMT

Hey, sure I can help. First, Can you point me to where the free trial info is, so I can try it out to see; be sure I'm getting at the same thig you are. Second, Viya has more than one authentication mechanism. Are you sure it's configured to use user/pw? They've gone away from that due to 'security' and generally use the authcode mechanism in deployments these days; but I don't know how this is set up. Did you try the authcode path? In the screen shot it shows where it asks you which mechanism to use. Did you try the other? Have you successfully connected to it using any other client? Did you get instructions from the free trial saying how to connect to it (that wouldn't be for saspy, but for Studio or something)?

Thanks,

Tom

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

sastpw — Fri, 13 Sep 2024 13:31:22 GMT

Ok, well, I googled viya free trial and got to it. I guess it's the same as what you're using. This is set up for authcode authentication, like I would have guessed. That requires you to go to a web page and sign in to get a one time authcode to use to sign in. Like when you log on to anything on the internet these days and they send you a one time use code you have to enter.

>>> sas = saspy.SASsession(url='https://azureuse011476.my-trials.sas.com')
To connect to Viya you need either an authcode or a userid/pw. Neither were provided.
Please enter which one you want to enter next. Type one of these now: [default=authcode | userid]:
The PKCE required url to authenticate with is https://azureuse011476.my-trials.sas.com/SASLogon/oauth/authorize?client_id=SASPy&response_type=code&code_challenge_method=S256&code_challenge=3f5_r3_ynBTMoAPlvDLAI6BTu8LdVLuXgePKMOmstMg
Please enter authcode: Q_mq25QG-GzdUPS_GzcFjhSJCWbdfhRI
Please enter the SAS Context you wish to run. Available contexts are: ['Import 9 service compute context', 'SAS Visual Forecasting compute context', 'Data Mining compute context', 'CAS Formats service compute context', 'CAS Management service compute conte
xt', 'SAS Job Execution compute context', 'SAS Studio compute context', 'Natural Language Conversations service compute context', 'SAS Model Manager compute context', 'SAS Backup job compute context'] SAS Studio compute context
SAS server started using Context SAS Studio compute context with SESSION_ID=b6181d9f-a809-41ee-9997-f136a2cf02e4-ses0000
>>> sas
Access Method = HTTP
SAS Config name = default
SAS Config file = /r/sanyo.unx.sas.com/vol/vol810/u81/sastpw/.config/saspy/sascfg_personal.py
WORK Path = /opt/sas/viya/config/var/tmp/compsrv/default/b6181d9f-a809-41ee-9997-f136a2cf02e4/SAS_work239F0000016D_sas-compute-server-035b3e9a-339d-470c-8cf2-11a28d5e0de5-4m7d5/
SAS Version = V.04.00M0P03182024
SASPy Version = 5.100.3
Teach me SAS = False
Batch = False
Results = Pandas
SAS Session Encoding = utf-8
Python Encoding value = utf_8
SAS process Pid value = 365
SASsession started = Fri Sep 13 09:27:51 2024

>>> sas.assigned_librefs()
['SASHELP', 'MAPS', 'MAPSSAS', 'MAPSGFK', 'SASUSER', 'WORK']
>>>

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

sastpw — Fri, 13 Sep 2024 13:44:02 GMT

And, just to show you can get there from the SAS_Kernel too (which just uses SASPy under the covers). Given the following Configuration Definition in my sascfg_personal.py:

vft = {'url' : 'https://azureuse011476.my-trials.sas.com',
'context' : 'SAS Studio compute context',
}

I can connect the same (BTW, at the prompt for authcode or userid, since the default is authcode, you can just hit enter - that's why you don't see 'authcode' typed in):

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

navdeepk — Fri, 13 Sep 2024 16:53:07 GMT

@sastpw Thanks for the detailed info, I am able to connect to saspy via python kernel, but through sas kernel I am directly getting unauthenticated error

[<class 'saspy.sasexceptions.SASHTTPauthenticateError'>, SASHTTPauthenticateError('Failure in GET AuthToken. Status=401\nResponse=b\'{"error":"unauthorized","error_description":"Bad credentials"}\''), <traceback object at 0x11ac1c0c0>]

It is not asking for a prompt to provide the auth key like it did in python. Is there any config step I missing here?

Also every time I want to use a new session should I get that auth key or is there a one time solution available?

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

navdeepk — Fri, 13 Sep 2024 17:32:49 GMT

Its now working with sas kernel as well, after removing the .authinfo from home dir its now asking for the prompt. Can we do anything so that the prompt is not needed any more and as soon as I launch a new kernel it gets connected to sas viya?

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

sastpw — Fri, 13 Sep 2024 18:34:51 GMT

It doesn't look like it. The way that viya system's configured, it not only requires a unique authcode every time you connect, but the url for getting the code is a different one every time also, so you're forced to have to try to connect, get the unique url and then provide the code that you get from that. This has nothing to do with saspy (though I support it as a connection mechanism), it's viya that's configured this way as the only way to connect to it.

Previously when they came up with this authcode scheme, the URL was fixed, so you could at least go get the code and then pass it in on the SASsession call as below. But now it uses a PKCE URL which is required and precludes being able to even know the url to get a code from because the url changes every time, just like the code. It's all in the name of security it seems. And yes, it's no fun, but I can't fix that. If they enables user/pw authentication, you could have used your creds in an authinfo file and it would just connect you like you (anyone) want(s). But that's not allowed, only the PKCE authcode scheme.

>>> sas = saspy.SASsession(cfgname='vft', authcode='VhZSA1xZVOskqT8aMWeu4gMEyGO7ZEiq')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/opt/tom/github/saspy/saspy/sasbase.py", line 598, in __init__
self._io = SASsessionHTTP(sascfgname=self.sascfg.name, sb=self, **kwargs)
File "/opt/tom/github/saspy/saspy/sasiohttp.py", line 751, in __init__
self.sascfg = SASconfigHTTP(self, **kwargs)
File "/opt/tom/github/saspy/saspy/sasiohttp.py", line 518, in __init__
js = self._authenticate(user, pw, authcode, client_id, client_secret, jwt, cv)
File "/opt/tom/github/saspy/saspy/sasiohttp.py", line 623, in _authenticate
raise SASHTTPauthenticateError(msg)
saspy.sasexceptions.SASHTTPauthenticateError: Failure in GET AuthToken.
A PKCE URL is configured to be used to acquire an authcode with is system, but a non-PKCE authcode was passed in.
Failure in GET AuthToken.
>>> sas = saspy.SASsession(cfgname='vft', authcode='IOBhsXdPFv4P1LvWUZcFLqCAZKgCNzzN')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/opt/tom/github/saspy/saspy/sasbase.py", line 598, in __init__
self._io = SASsessionHTTP(sascfgname=self.sascfg.name, sb=self, **kwargs)
File "/opt/tom/github/saspy/saspy/sasiohttp.py", line 751, in __init__
self.sascfg = SASconfigHTTP(self, **kwargs)
File "/opt/tom/github/saspy/saspy/sasiohttp.py", line 518, in __init__
js = self._authenticate(user, pw, authcode, client_id, client_secret, jwt, cv)
File "/opt/tom/github/saspy/saspy/sasiohttp.py", line 623, in _authenticate
raise SASHTTPauthenticateError(msg)
saspy.sasexceptions.SASHTTPauthenticateError: Failure in GET AuthToken.
A PKCE URL is configured to be used to acquire an authcode with is system, but a non-PKCE authcode was passed in.
Failure in GET AuthToken.
>>>

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

navdeepk — Fri, 13 Sep 2024 18:58:23 GMT

Okay Got it. Thanks for the clarification guys.

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

navdeepk — Thu, 17 Oct 2024 12:52:50 GMT

Hi, I am trying to read a file from my jupyter notebook how do I send this file or is there any way to read file (either from local or from was drive). Can someone provide me a code snippet and how to do it.

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

sastpw — Thu, 17 Oct 2024 13:40:44 GMT

You can use saspy to upload/download file between client and server. From the SAS Kernel, you can't do anything but submit SAS code, so I don't know how you would do that. FWIW, the sas.submitLST() method from a python Kernel is the equivalent of the SAS Kernel, and you can do so much more w/ python. Just sayin.

Here's an example of using upload (download is similar) to upload a sas data set (can be any file) to the work directory of a viya deployment; that's about the only dir in viya you have write permission to.

>>> sas
Access Method = HTTP
SAS Config name = tth
SAS Config file = /opt/tom/github/saspy/saspy/sascfg_personal.py
WORK Path = /opt/sas/viya/config/var/tmp/compsrv/default/6eca835b-7b16-48df-af86-6dad81576f75/SAS_workF01B000001BE_sas-compute-server-094e063f-11eb-450c-88a6-8261f5b3c3e1-56/
SAS Version = V.04.00M0P10142024
SASPy Version = 5.100.3
Teach me SAS = False
Batch = False
Results = Pandas
SAS Session Encoding = utf-8
Python Encoding value = utf_8
SAS process Pid value = 446
SASsession started = Thu Oct 17 09:23:32 2024

>>> sas.list_tables('work')
[]
>>> sas.dirlist(sas.workpath)
['sasmac3.sas7bcat', 'sasmacr.sas7bcat', 'sastmp-000000004.sas7bitm', 'sas.lck', 'sasgopt.sas7bcat', 'profile.sas7bcat', 'regstry.sas7bitm']
>>> log = sas.upload('a.sas7bdat', sas.workpath)

>>> for item in log: print(item, ':', log[item])
...
Success : True
LOG : 108 filename _sp_updn
108! '/opt/sas/viya/config/var/tmp/compsrv/default/6eca835b-7b16-48df-af86-6dad81576f75/SAS_workF01B000001BE_sas-compute-server-094e
108! 063f-11eb-450c-88a6-8261f5b3c3e1-56//a.sas7bdat' recfm=N permission='';

109 filename _sp_updn;
NOTE: Fileref _SP_UPDN has been deassigned.

>>>

>>> sas.list_tables('work')
[('A', 'DATA')]
>>> sas.dirlist(sas.workpath)
['sasmac3.sas7bcat', 'sasmacr.sas7bcat', 'a.sas7bdat', 'sastmp-000000004.sas7bitm', 'sas.lck', 'sasgopt.sas7bcat', 'profile.sas7bcat', 'regstry.sas7bitm']
>>> sd = sas.sasdata('a')
>>> sd.columnInfo()
Member Num Variable Type Len Pos
0 WORK.A 1.0 x Num 8.0 0.0
>>>

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

navdeepk — Thu, 17 Oct 2024 14:02:01 GMT

So cant we upload file in the Sas drive and access it here? I basically need to upload a csv file and then access it in my code.

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

sastpw — Thu, 17 Oct 2024 14:28:00 GMT

I'm afraid I don't know. Were there instructions that came with the free trial you're using?

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

navdeepk — Thu, 17 Oct 2024 19:05:23 GMT

No, I was able to upload the file and run some code on it using saspy. But even here the uploaded csv is temporary and goes on a random link right. If I wish to run the code again I have to again upload it. Is there any permanent solution for this. Also this was working fine with saspy (python kernel) but with Sas kernel its not the case. From Sas kernel I was not able to upload the file as well.

Re: Query Regarding SAS Kernel connection through https method in Jupyter notebook.

sastpw — Thu, 17 Oct 2024 19:24:28 GMT

Yes, that all sounds correct. The SAS_Kernel is just a jupyter extension that calls SASPy under the covers, so all you can do in a SAS notebook is execute SAS code. A Python notebook lets you use SASPy directly and have all the functionality at your disposal. But, in either case, it is just a connection to a single, one time use, SAS Process in a container, in a pod, on the K8S deployment that's Viya. SASPy isn't a Viya application, like say SAS Studio, which is part of Viya itself. I have to believe that SAS Studio would have a way to access the SAS Drive and upload files from your client.

I have to admit, I don't use any of that which is why I don't simply have the answer for you. What would need to happen, is for any SAS session you spin up and connect to in the Viya deployment, there would have to be a libref or fileref that it knows about and can access the 'Drive' you have with whatever data you have in it. I just an not familiar with any of that, but I will do some more investigation to see if I can figure it out. If a SAS session itself can access that, then it should be doable from SASPy. If all of that has to be implemented by a Viya client, and SAS itself had no concept of the SAS Drive component in the Viya deployment (there are hundreds of components in a Viya deployment), then you can't get at any of that from SAS directly via saspy because it's only connected to the SAS process in Viya, not all of the other stuff.

Let me try to figure this out and see what I come up with!