 |
|
| DBLOAD Procedure Reference |
Creating Customized View Descriptors
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 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.
|
|
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.