問題描述
我已經創建了一個 SAS 存儲過程,并且還能夠通過 SAS 管理控制臺創建一個 Web 服務,
I have a created a SAS Stored process and was also able to create a web service through SAS Management Console for the same ,
我想通過 Python 在 Web 服務中執行該存儲過程,并希望將存儲過程生成的數據集存儲在 Python 中的數據框中.
I want to execute that stored process in the web service through Python , and would like to store the data set generated by the stored process in a data frame in Python .
如果可以,我將非常感激該過程是可能的,如果是,我應該如何進行.
I would really appreciate if I could that the process is possible , and If yes , how should I proceed with it.
推薦答案
我對python不太了解,但是貌似可以接收JSON格式的數據(見Python - 解析 JSON 數據集)
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)
SASjs 框架使得在 SAS 9 和 Viya 上構建 SAS Web 服務變得超級容易,例如:
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)
這篇關于在 Python 中提取 SAS 存儲過程 Web 服務并將其存儲在數據框中的文章就介紹到這了,希望我們推薦的答案對大家有所幫助,也希望大家多多支持html5模板網!