ACCESS Procedure Reference

Editing Statements

SAS/ACCESS editing statements enable you to drop or rename items, list items, reset names, and so on in a descriptor. All of the statements can be used when you are creating a descriptor. The ASSIGN=, SELECT, RESET, and UNIQUE= statements cannot be used when you are changing a descriptor.

When creating or changing an access descriptor, place editing statements after the last database definition statement. All editing statements are optional.

The following list shows the basic syntax of each editing statement:

ASSIGN=Y| N;

UNIQUE=Y| N;

DROP item-name | index-number...;

FORMAT item-name | index-number <=> format...;

QUIT | EXIT;

RENAME item-name | index-number <=> SAS-name...;

RESET ALL | item-name | index-number...;

SELECT ALL | item-name | index-number...;

SUBSET selection-criteria;

These statements are described in detail in the following sections.

Top of Page