Summary of Strategy Features


Table 1.1: Summary of Strategy Features for Moving or Accessing SAS Files

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:

  • Relational databases

    • CA-OpenIngres, DB2 for OS/390, DB2 for UNIX and PC operating environments, Informix, ODBC, Oracle, Oracle Rdb, and SYBASE

  • Nonrelational databases

    • ADABAS, CA-IDMS, IMS-DL/I, and SYSTEM 2000

  • PC files

    • PC file formats Excel and Lotus

[**] 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.




Moving and Accessing SAS 9.1 Files
Moving And Accessing SAS 9.1 Files
ISBN: 1590472306
EAN: 2147483647
Year: 2004
Pages: 109
Authors: SAS Institute

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net