Moving and Accessing SAS Files between Operating Environments

Summary of Strategy Features

Here is a summary of the features of each strategy that you can use to move or access SAS files.

Summary of Strategy Features for Moving or Accessing SAS Files
Features	Strategies That Can Be Used
Features	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 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 the SAS/CONNECT User's Guide or SAS/SHARE User's Guide. * 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. **** 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.

Top of Page