The SAS/ACCESS Interface to SYSTEM 2000

Overview of the SAS/ACCESS Interface to SYSTEM 2000

SAS/ACCESS software provides an interface between SAS and SYSTEM 2000 database management software. With the SAS/ACCESS interface, you can

create SAS/ACCESS descriptor files by using the ACCESS procedure.
directly access data in SYSTEM 2000 databases from within a SAS program by using the descriptor files created with the ACCESS procedure.
extract SYSTEM 2000 data and place it in a SAS data file by using the ACCESS procedure or the DATA step.
load data into a SYSTEM 2000 database by using the DBLOAD procedure.
update data in SYSTEM 2000 databases by using the SQL procedure, SAS/FSP software, or the APPEND procedure. The SQL procedure can also be used to join SAS data files, PROC SQL views, and SAS/ACCESS view descriptors.
directly access data in SYSTEM 2000 databases by using the QUEST procedure with SYSTEM 2000 statements.

The SAS/ACCESS interface consists of

the interface view engine, which enables you to use SYSTEM 2000 data in SAS programs in the same way that you use SAS data. You can print, plot, and chart the data described by the descriptor files, use the descriptor files to create other SAS data files, and so on.
the ACCESS procedure, which enables you to describe SYSTEM 2000 data to SAS and store the description in SAS/ACCESS descriptor files.
the DBLOAD procedure, which enables you to create and load SYSTEM 2000 databases using data from SAS data sets.
the QUEST procedure, which enables you to access SYSTEM 2000 and issue SYSTEM 2000 statements from SAS.

You might need to combine data from several SYSTEM 2000 databases or from external databases, such as DB2 or SAS 6 and later SAS data sets. Such combinations are not only possible but easy to do. SAS can distinguish between SAS data files, SAS/ACCESS descriptor files, and other types of SAS files, and the software will use the appropriate access method.

A SYSTEM 2000 Database, Access Descriptor Files, and View Descriptor Files illustrates the relationships of a SYSTEM 2000 database, access descriptors, and view descriptors.

A SYSTEM 2000 Database, Access Descriptor Files, and View Descriptor Files

[Relationships Among a SYSTEM 2000 Database, Access Descriptor Files, and View Descriptor Files]

Top of Page