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

Extract SAS Stored Process web Service in Python and store it in a Data Frame(在 Python 中提取 SAS 存储过程 Web 服务并将其存储在数据框中)
本文介绍了在 Python 中提取 SAS 存储过程 Web 服务并将其存储在数据框中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

问题描述

我已经创建了一个 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 服务并将其存储在数据框中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

patching a class yields quot;AttributeError: Mock object has no attributequot; when accessing instance attributes(修补类会产生“AttributeError:Mock object has no attribute;访问实例属性时)
How to mock lt;ModelClassgt;.query.filter_by() in Flask-SqlAlchemy(如何在 Flask-SqlAlchemy 中模拟 lt;ModelClassgt;.query.filter_by())
FTPLIB error socket.gaierror: [Errno 8] nodename nor servname provided, or not known(FTPLIB 错误 socket.gaierror: [Errno 8] nodename nor servname provided, or not known)
Weird numpy.sum behavior when adding zeros(添加零时奇怪的 numpy.sum 行为)
Why does the #39;int#39; object is not callable error occur when using the sum() function?(为什么在使用 sum() 函数时会出现 int object is not callable 错误?)
How to sum in pandas by unique index in several columns?(如何通过几列中的唯一索引对 pandas 求和?)