SAS Data Provider comparison of various connection methods

zhaozj2021-02-16  110

SAS is from 8.2 to support various resources to call SAS in other environments.

In SAS8.2 uses the most common Intrnet technology to interact between Web Server and SAS, all processes are used in SAS, although it is a B / S structure, but the performance layer, business layer, and data layers are Didn't separate, so IT technology application

It provides an interface has a total of external environment, and there are several ways of calling in the SAS9.1 environment, which is taken from the original text of the SAS website:

Provider-Specific FeaturesSAS Local Data ProviderSAS / SHARE Data ProviderSAS IOM Data ProviderSAS OLAP Data Providersupports random access using the ADO adOpenDynamic cursor type and recordset bookmarksyesyesyesnosupports simultaneous user updatesnoyesyesyessupports SQL processingnoyesyesnoprovides read and update access to all data sets available in a SAS sessionnoyesyesnoprovides 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 noyesyesyesprovides access to via Version SAS data files 7 and later SAS / SHARE serversnoyesnonoprovides access to SAS data files on Version 8 and later SAS IOM serversnonoyesnoprovides access to SAS data files on SAS 9.1 and later SAS OLAP servers nononoyesprovides read-only access to Version 6 and later SAS data sets created on a Windows system without a SAS session yesnononoprovides read-only access to Transport Files and Data Sets Created by Sas Versio N7 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. YesnonoSupports MDX ProcessingnonoYes

转载请注明原文地址:https://www.9cbs.com/read-10278.html

New Post(0)