space
Previous Page | Next Page

ACCESS Procedure Reference

CREATE Statement (Required)



Creates an access descriptor or a view descriptor.
Applies to: access descriptors and view descriptors

Syntax

Syntax

CREATE libref.member-name.ACCESS|VIEW;

Details

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

You can use the same CREATE statement to create access descriptors and view descriptors (specify the 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, re-submit the statements for processing.

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

space
Previous Page | Next Page | Top of Page