問題描述

我已經(jīng)創(chuàng)建了一個(gè) SAS 存儲(chǔ)過程，并且還能夠通過 SAS 管理控制臺(tái)創(chuàng)建一個(gè) Web 服務(wù)，

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 服務(wù)中執(zhí)行該存儲(chǔ)過程，并希望將存儲(chǔ)過程生成的數(shù)據(jù)集存儲(chǔ)在 Python 中的數(shù)據(jù)框中.

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 .

如果可以，我將非常感激該過程是可能的，如果是，我應(yīng)該如何進(jìn)行.

I would really appreciate if I could that the process is possible , and If yes , how should I proceed with it.

推薦答案

我對(duì)python不太了解，但是貌似可以接收J(rèn)SON格式的數(shù)據(jù)(見Python - 解析 JSON 數(shù)據(jù)集)

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 上構(gòu)建 SAS Web 服務(wù)變得超級(jí)容易，例如:

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)

這篇關(guān)于在 Python 中提取 SAS 存儲(chǔ)過程 Web 服務(wù)并將其存儲(chǔ)在數(shù)據(jù)框中的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！