About Ullsokk

Ullsokk · ‎09-15-2020

Is there a way to control which observaion\local instance to show in Model Studio's Model interpretability plots? I can see five different cases and how the outcome (churn) depends on different variables. But is there a way to select which cases I want to inspect? In general, I am more interested in understanding why a high probability customer has a high probability - e.g. a customer in the top 1% of churn probability. Is there any way to specify e.g that I want to inspect customers with high probability?

Ullsokk · ‎09-15-2020

Thansks, I did not know about cas spesific symput statements and %let beeing resolved beforehand. Got it working using the casl symput

Ullsokk · ‎09-15-2020

I am trying to check if the dataset is already loaded to cas using this code: %let data= 'MyDataSet'; proc cas; table.tableExists result =r / name="&data" caslib="MyCasLib"; print(r); if r=0 then do; print("table is not loaded"); %let loaded = 0; end; else ; print("Table already loaded"); quit; The code works if I hard code the table name, but not if I try to use a macro value, and enter "MyDataSet" in stead. From the log, I can see that the macro variable is not resolved when I try to use the macro variable &data

Ullsokk · ‎09-11-2020

Tried getting a list of all applications, but got an error message; "error":"insufficient_scope","error_description":"Insufficient scope for this resource","scope":"uaa.admin clients.read clients.adm in sasapp zones.uaa.admin Do I need to register a new client\app with an admin scope, to retrieve the list of registered applications?

Ullsokk · ‎09-10-2020

Thank you! Is this (the fact that group ID as opposed to name is expected) explicitly stated somewhere official? Just wondering I am missing some major part of the documentation, as I can't find this in writing anywhere

Ullsokk · ‎09-10-2020

Thanks! Very familiar with the article, I have been using it a lot. Is this particular API documented somewhere? I can't find any official documentation regarding this particular GET request. A link would be much appreciated if you have one

Ullsokk · ‎09-10-2020

Where can I find an overview of all registered applications\clients from the VIYA REST API? I have registered at least one client, and possibly some duplicates. But I cannot find any overview of registered clients in either SAS VIYA Environment manager or in the API documentation. Where are the clients stored?

Ullsokk · ‎09-10-2020

I am trying to register an application using the following python code: headers = { 'Content-Type': 'application/json', 'Authorization': 'Bearer ' + IDtoken , } data = { "client_id": "myclientid", "client_secret": "myclientsecret", "scope": ["openid", "group1"], "authorized_grant_types": ["authorization_code","refresh_token"], "redirect_uri": "urn:ietf:wg:oauth:2.0:oob" } I have one custom group in Viya that I want to include in scope, in addition to "openid". Am I supposed to use the group name or the group ID in the request? The group name is something like MF_modelfactory_RW, and group id is, by happenstance, "group1" (just as the example code).

Ullsokk · ‎09-10-2020

Can confirm that this worked for med with the correctly placed semi colon, but only in SAS studio V in Viya. The appilcation code however will be triggered as a DI stuidio generated sascode running in a 9.4. environment, so I guess one sollution is to create a new user just for application authentication, or getting the approach without password authentication to work (using a refresh token if I understand correctly)

Ullsokk · ‎09-09-2020

I was using this as a guide:https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2019/3232-2019.pdf Which seems to have a syntax error, stating that the auth is supposed to be separated by a semicolon: proc http url="http:\\viya-webservice.mydomain.com"; OAUTH_BEARER=SAS_SERVICES; run; Tried again with the auth_bearer inside the first semicolon. In both viya sas studio V and EG 8.2 on sas 9.4, I get a 401 unautherized error. The syntax does not seem to be regonized, but I get no error message apart from the response file beeing missing when I try to read it.

Ullsokk · ‎09-08-2020

I can't get the option to work. Tried placing it everywhere, both in sas studio 9.4, E.G. 9.4 and sas studio V on Viya. I assume the data\in is not used when using this method? * did not use this: %let str ="grant_type=password%str(&)username=&sysuserid.%str(&)password=&password."; proc http url="https://aiu-viya-server.com/SASLogon/oauth/token" method="POST" Webusername="MyApp" webpassword="password" /*in=&str.*/ headerout=hdrs headerout_overwrite out=out ; headers "Accept"="application/json"; OAUTH_BEARER=SAS_SERVICES; run; Where is the OAUTH_BEARER supposed to go? And is the in\data suppose to be missing? Or contain something like grant_type=password%str(&)username=&somemacrovalue.%str(&)password=&anothermacrovalue. In any case, the application code will not be running in a Viya\ SAS studio V environment, but as a sas code deployed through DI studio. But it seems like a better approach, if I understand this correctly, is to use a refresh token (no username and password), and to enter the refresh token in the code. So I basically have to change the way of obtaining an access token to passing a refresh token. Will look into the link you provided.

Ullsokk · ‎09-08-2020

Couldnt get the syntax right with more than one line. I ended up using Proc Stream instead. But would be interested in an example that works on my multi line json, and gives an output file like my example.

Ullsokk · ‎09-08-2020

Thanks! looks promising, the files seems to look right when using the &streamdelim (since it starts with brackets) proc stream outfile=json; begin &streamdelim;

Ullsokk · ‎09-08-2020

I am trying to pass a json to the SAS Viya API by using proc http. My json data needs to contain some macro variables for table uri and template href and uris In python, the data looks like this: data = { "name": name, "dataTableUri": dataTableUri, "type": "predictive", "pipelineBuildMethod": "template", "analyticsProjectAttributes": { "targetVariable" : target, "partitionEnabled" : True, "targetEventLevel" : "1" }, "settings": { "applyGlobalMetadata" : "false" }, "links": [ { "method": "GET", "rel": "initialPipelineTemplate", "href": pipelineHref, "uri": pipelineUri, "type": "application/vnd.sas.analytics.pipeline.template" } ] } In sas, I am trying the following to create the json data: filename json_in temp; data _null_; file json_in; input text $500.; textResolved=dequote(resolve(quote(text))); put _infile_; datalines; {"name": name, "dataTableUri": &dataTableUri., "type": "predictive", "pipelineBuildMethod": "template", "analyticsProjectAttributes": { "targetVariable" : &target, "partitionEnabled" : True, "targetEventLevel" : "1" }, "settings": { "applyGlobalMetadata" : "false" }, "links": [ { "method": "GET", "rel": "initialPipelineTemplate", "href": &pipelineHref., "uri": &pipelineUri., "type": "application/vnd.sas.analytics.pipeline.template" } ] } But I just get problems with unbalanced qoutes. Creating the json without using deqoute(resolve(qoute(... ))) to resolve the macro varaibles in this way works, but doesnt solve my problem, since I need to fill in those values filename json_in temp; data _null_; file json_in; input ; put _infile_; datalines; {"name": name, "dataTableUri": &dataTableUri., "type": "predictive", "pipelineBuildMethod": "template", "analyticsProjectAttributes": { "targetVariable" : &target, "partitionEnabled" : True, "targetEventLevel" : "1" }, "settings": { "applyGlobalMetadata" : "false" }, "links": [ { "method": "GET", "rel": "initialPipelineTemplate", "href": &pipelineHref., "uri": &pipelineUri., "type": "application/vnd.sas.analytics.pipeline.template" } ] } run;

Ullsokk · ‎09-07-2020

I have translate our Viya API code from a python POC to SAS. I am using proc http to do the REST calls. In the first authenication, I used a user prompt to get the password in python. I was going to implement something using getPass to retrieve the user password in python. I am using &sysuserid to get the logon id, but is there anyway to get the password from the session, akin to getPass? Or retrieving it from a user prompt? I do want to avoid hardcoding the password for obvious reasons. I need the password and username to authenticate and obtain the access_token.

Online Status	Offline
Date Last Visited	‎04-11-2023 06:04 AM

How can I get lime plot for a specific observation in sas viya 3.5?

Setting default value in sas task filter based on another filter

Re: Bar chart groups changing order

Re: Bar chart groups changing order

Bar chart groups changing order

Re: Characters turned into Chinese using sql insert from Viya

Re: Characters turned into Chinese using sql insert from Viya

Re: Characters turned into Chinese using sql insert from Viya

Re: Characters turned into Chinese using sql insert from Viya

Characters turned into Chinese using sql insert from Viya

How do I find the code associated with a scheduled job?

Re: VIYA api access best practice

TRe: VIYA api access best practice

VIYA api access best practice

How do I use the Tags in Model Manager?

Is there a way to select which local instance\observation to inspect i...

Re: Can't use macro variable in proc CAS

Can't use macro variable in proc CAS

Re: Where can I find all registered clients\applications for REST API?

Re: Scope groups in API - use name or group id?

Re: Where can I find all registered clients\applications for REST API?

Where can I find all registered clients\applications for REST API?

Scope groups in API - use name or group id?

Re: Passing user password to REST authentication in SAS

Re: Passing user password to REST authentication in SAS

Re: Passing user password to REST authentication in SAS

Re: How to resolve macro variables in json using datalines

Re: How to resolve macro variables in json using datalines

How to resolve macro variables in json using datalines

Passing user password to REST authentication in SAS

SAS Analytics Explorers