Chapter Contents

Previous

Next

CREATE

Required statement
Applies to:	access descriptor and view descriptor

Details

The CREATE statement identifies an access descriptor or view descriptor that you want to create.

To create the descriptor, use a three-level name. The first level is the libref of the SAS data library where you want the descriptor stored. You can store the descriptor in a temporary (WORK) or permanent SAS data library. The second level is the access descriptor's name (that is, the member name). The third level is the type of SAS file: ACCESS for access descriptors and VIEW for view descriptors.

You can create access descriptors and view descriptors in the same procedure statement (view descriptors directly following the access descriptors that they describe), unless you specify the ACCDESC= option in the PROC ACCESS statement. Then, the CREATE statement will create only view descriptors.

When you submit a CREATE statement for processing, the SAS/ACCESS interface checks the statement for errors. The descriptor is not actually written until the next CREATE or RUN statement is processed. If the SAS/ACCESS interface finds errors, error messages are written to the SAS log and processing is terminated. After you correct the error, resubmit the statements for processing.

The database-identification and DROP statements cannot be specified when creating a view descriptor.

Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.