Extract SAS Stored Process Web Service In Python And Store It In A Data Frame

I have a created a SAS Stored process and was also able to create a web service through SAS Management Console for the same , I want to execute that stored process in the web serv

Solution 1:

I don't know much about python but it appears that it is possible to receive data in JSON format (see Python - Parsing JSON Data Set)

The SASjs framework makes it super easy to build SAS web services on both SAS 9 and Viya, eg:

%let appLoc=/Public/app;  /* Configure Metadata or Viya Folder location here */
filename mc url "https://raw.githubusercontent.com/sasjs/core/main/all.sas";
%inc mc; /* compile macros */
filename ft15f001 temp;
parmcards4;
  %webout(OPEN)
  proc sql;
  create table areas as select distinct area from sashelp.springs;
  %webout(OPEN)
  %webout(OBJ,areas)
  %webout(CLOSE)
;;;;
%mp_createwebservice(path=&appLoc/common,name=appinit)