在 Python 中提取 SAS 存储过程 Web 服务并将其存储在数据框中

2022-01-08 00:00:00 python pandas sas

问题描述

我已经创建了一个 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)

相关文章