Previous Page | Next Page

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
XPORT Engine
XML Engine
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.

Previous Page | Next Page | Top of Page