SAS IT技术(SAS Data Provider ) 各种连接方式的比较

最新推荐文章于 2024-07-02 19:31:34 发布

原创最新推荐文章于 2024-07-02 19:31:34 发布 · 2.7k 阅读

CC 4.0 BY-SA版权

文章标签：

90 篇文章

订阅专栏

博客指出SAS自8.2后支持在其他环境调用其资源，在SAS 8.2普遍用IntrNet技术通过CGI在WEB SERVER和SAS间交互，虽为B/S结构但各层未分开，IT技术应运而生。还提及在SAS 9.1环境下有多种调用方式。

SAS自8。2后开始支持在其它环境中调用SAS的各种资源

在SAS8。2使用最普遍的IntrNet技术通过CGI在WEB SERVER和SAS间交互，本质上所有流程都作用于SAS上，虽其架构上是B/S结构，但表现层、业务层和数据层却没分开，故IT技术应用而生

其提供接口已共外部环境调用，在SAS9.1环境下有以下几种调用方式，摘自SAS网站原文：

Provider-Specific Features	SAS Local Data Provider	SAS/SHARE Data Provider	SAS IOM Data Provider	SAS OLAP Data Provider
supports random access using the ADO adOpenDynamic cursor type and recordset bookmarks	yes	yes	yes	no
supports simultaneous user updates	no	yes	yes	yes
supports SQL processing	no	yes	yes	no
provides read and update access to all data sets available in a SAS session	no	yes	yes	no
provides a choice of either exclusive access (member-level lock) or multiple user access (record-level lock) to SAS data files, selectable on a per-rowset open basis	no	yes	yes	yes
provides access to SAS data files via Version 7 and later SAS/SHARE servers	no	yes	no	no
provides access to SAS data files on Version 8 and later SAS IOM servers	no	no	yes	no
provides access to SAS data files on SAS 9.1 and later SAS OLAP servers	no	no	no	yes
provides read-only access to Version 6 and later SAS data sets created on a Windows system without a SAS session	yes	no	no	no
provides read-only access to transport files and data sets created by SAS Version 7 or later on any of the following platforms: Solaris, HP/UX, RS 6000 AIX, MIPS Intel ABI, Windows, OS/2, OpenVMS Alpha. Does not require a SAS session.	yes	no	no	no
supports MDX processing	no	no	no	yes