Features | Strategies That Can Be Used | |||||
---|---|---|---|---|---|---|
CEDA | PROC CPORT/PROC CIMPORT | XPORT Engine | XML Engine | SAS/CONNECT DTS | SAS/CONNECT RLS and SAS/SHARE RLS | |
SAS Member Types Supported | Data File, PROC SQL views [*] , SAS/ACCESS views (Oracle and SYBASE), MDDB [*] | Library, Data Set, Catalog, Catalog entry | Library, Data Set | Data File | Library, Data Set, Catalog, Catalog entry, PROC SQL view, MDDB, External third-party databases [***] | Library, Data Set, Catalog [**] , Catalog entry [**] , PROC SQL view, MDDB, DATA Step view, SAS/ACCESS view, External third-party databases [***] |
Dynamic Translation or Create a File Format | Dynamic | Transport [****] | Transport [****] | XML | Dynamic | Dynamic |
SAS Versions Supported | SAS 8 and later | SAS 6 and later | SAS 6 and later [****] | SAS 8.2 and later | SAS 6 and later | SAS 6 and later |
Regression from a Later to an Earlier SAS Release | No | No | Yes | No | Yes | Yes |
Limited to Operating Environments that Use Directory-Based File Structures | Yes | No | No | No | No | No |
SAS Product License Required | Base SAS | Base SAS | Base SAS | Base SAS | SAS/CONNECT | SAS/CONNECT or SAS/SHARE |
[*] Data set (files) can have read, write, and update access. PROC SQL views and MDDBs are read-only. [***] SAS/CONNECT supports external text files and binary files. SAS/CONNECT and SAS/SHARE support third-party external databases by means of the Remote SQL Pass-Through Facility, but you must have a SAS/ACCESS license to access these databases. Here is a list of external files that SAS/CONNECT and SAS/SHARE support:
[**] SAS 9 does not support cross-operating environment access to catalog entries or catalogs in operating environments that are incompatible. For information about architecture groups, see SAS/CONNECT User's Guide or SAS/SHARE User's Guide . [****] The XPORT engine does not support features that were introduced in SAS 8 (such as long file and variable names ). If the XPORT engine is used to regress a SAS 8 or later SAS file to an earlier release, the features that are exclusive to SAS 8 and later are removed from the SAS file. Also, the transport formats that are produced by the XPORT engine and PROC CPORT are not interchangeable. |
For complete details about relational databases, see SAS/ACCESS for Relational Databases: Reference . For details about nonrelational databases, see SAS/ACCESS Interface to CA-Datacom/DB: Reference , SAS/ACCESS Interface to IMS: Reference , SAS/ACCESS DATA Step Interface to CA-IDMS: Reference ,or SAS/ACCESS Interface to SYSTEM 2000: Reference , as appropriate.