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.
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.