Products & Solutions / Enterprise Data Access

SAS/ACCESS® Interface to SYSTEM 2000®

A convenient way to access your most up-to-date nonrelational data

SAS/ACCESS Interface to SYSTEM 2000 brings together the resources you need for effective information delivery and lets you put these resources to work in a dynamic, syntax-free environment. With this out-of-the-box solution, you get the power and flexibility of SAS® to analyze and present data directly from your database.

Database integrity is not at risk because SAS/ACCESS fully supports the existing security features of SYSTEM 2000 software. Access to the database can be provided to as many, or as few, users as necessary.

With SAS/ACCESS Interface to SYSTEM 2000, you create a view to describe the specific data you'd like to access in your SAS application. Transparent to the user, the information in the view is passed to SYSTEM 2000 software. You can access data in SYSTEM 2000 software schemas and paths without having to create a SAS data file.

You begin by creating an access descriptor, which tells SAS the essential information about the SYSTEM 2000 software path you want to access. Then, you create a view descriptor to let SAS know which subsets of the data (typically rows or columns) you would like to use as input.

SAS then reads the data values just as if they were in a SAS data file. You are always assured that you are using the most current data because the data is read directly from the SYSTEM 2000 software database into your SAS application without creating an intermediate SAS data file. You save disk space because the data remains in the database. Only descriptive information is stored in the view.

Structured Query Language (SQL) can be used to update, delete or insert data into the SYSTEM 2000 software path you have described in your view. With SAS SQL, you can combine data from different databases with each other and with SAS data files to form a single output table.

In addition to creating views that describe SYSTEM 2000 data, SAS/ACCESS allows you to extract data directly from the database table and place the data in a SAS data file. You'll find these capabilities especially helpful if you are producing multiple reports or graphs with the same data.

SAS/ACCESS software also provides tools for creating and loading SYSTEM 2000 software databases without ever leaving your SAS session. You can include data from a SAS data file or a combination of SAS data files and data from other supported database management systems. The QUEST procedure provides a query and administrative interface that enables you to interactively retrieve data, update data, define a new database, assign passwords to a database, save or restore a database, and enable rollback. It gives users an interactive way to perform database administration tasks and to generate ad hoc queries and reports.

Ready to learn more?

Call us at 1-800-727-0025 (US and Canada) or request more information.