topic SAS BI Web services - RESTful JSON response - strign parameters only in SAS Programming

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.

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

rudfaden — Tue, 01 Nov 2022 19:54:54 GMT

I would use the proc json procedure to generate my json. https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n0nejfk9q0pzmnn181l92qk3ah2e.htm

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.

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

rudfaden — Mon, 07 Nov 2022 08:52:54 GMT

NO. I do not think that is possible. SAS only have string and number as datatypes.