When the DBLOAD procedure creates a new database, it always creates an
access descriptor and a view descriptor that matches the access descriptor. The default names are Work.
database.ACCESS
and Work.
database.VIEW.
If you do not like the default descriptors that PROC DBLOAD creates, submit a CREATE
statement and invoke the ACCESS procedure to create your own specific view descriptor.
Then return to PROC DBLOAD, specify the name that you created for 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. PROC DBLOAD 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 PROC ACCESS to create a view
descriptor that matches the SAS data file.
-
Use the RENAME
data set option in the DATA= argument. Use the KEEP or DROP option in the DATA= argument to
limit the SAS variables that are inspected.