NY Tracker

Re: How to change applicable users names after installation

NY — Tue, 08 Aug 2023 05:55:16 GMT

I suspected that would be the answer 😞 but had hope that someone would share some tips from experience.
Thank you very much for responding. I'll send a request to Tech Support.

How to change applicable users names after installation

NY — Mon, 07 Aug 2023 11:12:49 GMT

Our SAS system is running properly, without malfunctions for more than a year now 🙂

SAS 9.4M7, Windows Server, one machine.

To spice things up... I am required to change usernames for:

SAS Installer

SAS Spawned Server User (sassrv)

SAS Demo User (sasdemo)

I found in the documentation how to change password but not the usernames themselves, and would appreciate any help.

Thank you very much.

Re: SAS BI Web services - RESTful JSON response - strign parameters only

NY — Wed, 02 Nov 2022 06:29:51 GMT

Thank you for your reply @rudfaden .

You are right, proc json would work. But I'm trying to understand if I can use the simple way (defining output parameters in the STP) to send parameters that are not string in my reply. Any luck with that?

Thank you very much,

Nufar.

SAS BI Web services - RESTful JSON response - strign parameters only

NY — Sun, 30 Oct 2022 13:52:19 GMT

Hi Experts,

I have created a stored process with input and output parameters that I'm trying to call using SAS BI Web Services. My endpoint is JSON.

*ProcessBody; 
 
%global BANK 
        CALCULATIONTYPE 
        COMPANYID 
        CUSTOMERID 
        MODELCODE 
        PREVIOUSCALCULATIONDATE 
        PREVIOUSEXPECTEDLOSS 
        PREVIOUSLOSSGIVENDEFAULT 
        PREVIOUSPROBABILITYOFDEFAULT 
        QUESTIONNAIREGRADE; 
 
%STPBEGIN; 
 
*  End EG generated code (do not edit this line); 
 
 
proc printto log=" D:\RiskModels\RestLogs\web_service_test_%sysfunc(today(),yymmdd10.)-%sysfunc(compress(%sysfunc(time( ),time.),":")).log";
   run;
libname srcdata "D:\RiskModels\SourceData";
proc sql noprint;
select distinct Client_LGD format=16.8 into :lgd from srcdata.lgd_table where 
ID =&customerID;
quit;
%let probabilityOfDefault=0.5;
%let lossGivenDefault = &lgd;
%let expectedLoss = %sysevalf(&lgd. * &probabilityOfDefault.);


*  Begin EG generated code (do not edit this line); 
;*';*";*/;quit; 
%STPEND; 
 
*  End EG generated code (do not edit this line);

My output parameters were defined as DOUBLE, but in the response in my API tester tool (POSTMAN for example),

they all show as STRING.

{
    "outputParameters": {
        "expectedLoss": "0.22068032",
        "probabilityOfDefault": "0.5",
        "lossGivenDefault": "0.44136064"
    }
}

When I looked in SAS documentation the example shows a response with string variables only.

Does anyone succeed transfer numeric parameters?

https://documentation.sas.com/doc/en/itechcdc/9.4/wbsvcdg/n1wblekhip1yrln1fv2s5b6a2d9f.htm

Thank you very much,

Nufar.

How to send JSON request using SAS BI WEB services

NY — Wed, 28 Sep 2022 10:43:14 GMT

Hi Experts,

I have created a stored process with input and output parameters that I'm trying to call using SAS BI Web Services. See the SAS stp code below:

*ProcessBody; 
 
%global BANK 
        CALCULATIONTYPE 
        COMPANYID 
        CUSTOMERID 
        MODELCODE 
        PREVIOUSCALCULATIONDATE 
        PREVIOUSEXPECTEDLOSS 
        PREVIOUSLOSSGIVENDEFAULT 
        PREVIOUSPROBABILITYOFDEFAULT 
        QUESTIONNAIREGRADE; 
 
%STPBEGIN; 
 
*  End EG generated code (do not edit this line); 
 
 
proc printto log=" D:\RiskModels\RestLogs\web_service_test_%sysfunc(today(),yymmdd10.)-%sysfunc(compress(%sysfunc(time( ),time.),":")).log";
   run;

libname srcdata "D:\RiskModels\SourceData";

proc sql noprint;
select distinct Client_LGD format=16.8 into :lgd from srcdata.lgd_table where 
ID =&customerID;
quit;

%let probabilityOfDefault=0.5;
%let lossGivenDefault = &lgd;
%let expectedLoss = %sysevalf(&lgd. * &probabilityOfDefault.);
%let commentCodes = 1,2,3;


*  Begin EG generated code (do not edit this line); 
;*';*";*/;quit; 
%STPEND; 
 
*  End EG generated code (do not edit this line);

I'm using Postman to call the stored process in POST method. My endpoint is (I omitted the server name for this example):

https://server:443/SASBIWS/json/storedProcesses/RiskModels/web_service_test

The format of the request is JSON. See an example of a request below:

Body:{"bank":"bank_name","customerID":"12345678","companyID":"12345678","calculationType":"1","modelCode":"111","questionnaireGrade":70.5,"previousCalculationDate":"2022-08-09","previousProbabilityOfDefault":0.6,"previousLossGivenDefault":0.5,"previousExpectedLoss":0.3}

When I'm sending the JSON request with the header: "Content-Type: application/json "

the response is: "HTTP Status 415 – Unsupported Media Type".

My request never reaches the storedprocess server, it gets an error from the webserver.

So I guess my question is: What is the correct way to call SASBIWS in POST method using a JSON request.

Thank you very much,

Nufar.