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

Creating Your Own View Descriptor

When the DBLOAD procedure creates a new database, it always creates an access descriptor and a view descriptor that matches the access descriptor. Their default names are WORK.database-name.ACCESS and WORK.database-name.VIEW, respectively.

If you do not like the default descriptors that the DBLOAD procedure creates, issue the CREATE statement and invoke the ACCESS procedure to create your own specific view descriptor; then return to the DBLOAD procedure, specify your view descriptor, and load your data.

You must ensure that incoming SAS variables match the SYSTEM 2000 items in your view descriptor. You can have more components in your view descriptor than in the SAS data file or vice versa. The procedure matches input variables with the variables in the view descriptor by SAS names. If your SAS names do not match, do one of the following:

Use the ACCESS procedure to create a view descriptor that matches the SAS data file.
Use the RENAME data set option on the DATA= argument. Use the KEEP or DROP option in the DATA= argument to limit the SAS variables that are inspected.

Chapter Contents
Previous
Next
Top of Page