topic Re: How to create SAS web service using SAS stored process in SAS 9.4 and how to call the same in New SAS User

How to create SAS web service using SAS stored process in SAS 9.4 and how to call the same

sriramsahani — Thu, 22 Aug 2019 12:19:19 GMT

Hi All,

Do we have step by step procedure to create a SAS Web service using SAS stored process and how do we call it ?

Regards,

Sriram Sahani

Re: How to create SAS web service using SAS stored process in SAS 9.4 and how to call the same

AnandVyas — Fri, 23 Aug 2019 05:17:04 GMT

Hi @sriramsahani,

Thanks for asking this question. I tried to explore on this topic. I am sure you would have gone through the offical documentation of SAS for using BI Web Services. If not, here is the link to that: http://support.sas.com/documentation/cdl/en/wbsvcdg/64883/HTML/default/viewer.htm

Using this as ref. I was able to create a Web Service and view it via browser. I will later try to use Java to call this web service.

However for now I listing down the basic steps I have performed.

1) Create a STP for ex: MySTP and store it in your Metadata folder /MyTestFolder/MySTP
I added simple SAS code to the STP as below:

proc print data=sashelp.cars;
run;

2) Launch SMC and go the metadata folder location where you have stored your STP in Step 1.
3) Right click on MySTP and select deploy as Web service. It will ask you to give a name for your web service. lets call it MyWebService.
4) Select the default Web Service Markup URL from drop down and Hit Next. Leave the namespace as default. Incase you want to give a namespace, you can give it here. Click Next
5) Review the details and Hit Finish. This would deploy your web service to location /System/Services/MyWebService.
6) Go to browser and hit the URL: http://<SAS-Mid-Tier-Host-Name-Here>:7980/SASBIWS/rest/MyWebService/MySTP/dataTargets/_WEBOUT
7) If asked for Login, please provide LoginID/Pass which would have permissions to read the STP metadata.

Note: Your SAS Environment needs to be deployed with SAS BI Web Services for Java 9.4 in order to make this run. you can validate if this is installed in your environment or not by navigating to SMC -> Plugins -> Application Management -> Configuration Manager -> SAS Application Infrastructure -> BI Web Services for Java 9.4

HTH, Thanks!

Re: How to create SAS web service using SAS stored process in SAS 9.4 and how to call the same

AllanBowe — Wed, 13 Oct 2021 20:03:28 GMT

Another (perhaps simpler) approach is to write out your content directly from an STP to `_webout` and call it using YOURURL/SASStoredProcess/do?_program=/your/path/to/your/stp

STPs can be created very easily, eg with the following macro: https://github.com/sasjs/core/blob/main/meta/mm_createwebservice.sas

Some useful resources: