Browsing and Updating SYSTEM 2000 Data

Browsing and Updating SYSTEM 2000 Data Directly from SAS

The SAS/ACCESS interface to SYSTEM 2000 enables you to browse and update SYSTEM 2000 data directly from a SAS session or program. This section shows you how to use SAS procedures for browsing data and updating data described by SAS/ACCESS view descriptors. The examples given here use the database EMPLOYEE, and most of the examples use the view descriptor VLIB.EMPPOS, which you created earlier. See SAS/ACCESS Descriptor Files. For the definition of the other view descriptors, see Example Programs.

Note: Many of the examples used here involve deleting and inserting data. Before running these examples, check with your database administrator (DBA) to be sure the data in the database is correct. The data might have been changed by previous users. [cautionend]

Before you can browse or update SYSTEM 2000 data, you must be able to access the data by using an appropriate password and authorities. SYSTEM 2000 has various levels of passwords and authorities that enable you to display or browse data but not update values, or you might be able to update values but not change the definition of the database. For these examples, the SYSTEM 2000 password DEMO, which is the master password for the database EMPLOYEE, is stored in the view descriptors, so that you can use the SAS procedures used in these examples to update the database. For more information about SYSTEM 2000 passwords and authorities, see SYSTEM 2000 Software and Topics for Database Administrators.

It is also important, especially for updating data, that you have some understanding of how SYSTEM 2000 logical entries map into SAS observations. See Mapping Data between SAS and SYSTEM 2000.

Top of Page