SAS/ACCESS Interface to SYSTEM 2000 Data Management Software: Reference

Introduction

The SAS/ACCESS interface to SYSTEM 2000 software enables you to browse and update SYSTEM 2000 data directly from a SAS session or program. This chapter shows you how to use SAS procedures for browsing data and updating data described by SAS/ACCESS view descriptors. The examples in this chapter use the EMPLOYEE database, and most of the examples use the view descriptor VLIB.EMPPOS that you created in Defining SAS/ACCESS Descriptor Files. For the definition of the other view descriptors used in this chapter, see Example Data.

Note: Many of these examples involve deleting and inserting data. Before you attempt to run these examples, check with your database administrator (DBA) to be sure the data in the database are correct. [cautionend]

Before you can browse or update SYSTEM 2000 data, you must have access to the data through an appropriate password and authorities. SYSTEM 2000 software has several levels of passwords and authorities, and you may be allowed to display or browse data but not update values. Or you may be able to update values but not change the definition of the database. For these examples, the appropriate SYSTEM 2000 password (DEMO, which is the master password for the EMPLOYEE database) is stored in the view descriptors, so that you can use the SAS procedures described in this chapter to update the database.

Refer to SYSTEM 2000 Essentials and Information for the Database Administrator for more information on SYSTEM 2000 passwords and authorities.

In addition, it is important that you have some understanding of how SYSTEM 2000 logical entries map into SAS observations. This is especially important for updating. Refer to Mapping Data between the SAS System and SYSTEM 2000 Software.

Chapter Contents
Previous
Next
Top of Page