DROP

DROP

Drops the specified item so that it is not available for selection

Optional statement

Applies to: access descriptor

Syntax
Details

Syntax

DROP variable-identifier <...variable-identifier-n>;

Details

The DROP statement drops the specified variable from the access descriptor so that the variable is not available for selection when creating a view descriptor. The specified variable in the database remains unaffected by this statement.

If you drop a record, every item in the record is dropped.

The variable-identifier argument can be one of the following:

current SAS name for the item
positional equivalent, which is the number that represents the item, as given by the LIST statement
SYSTEM 2000 C-number of the database item.

For example, if you want to drop the third and fifth items, submit the following statement:

drop 3 5;

If you are creating an access descriptor in interactive line mode and want to mark an item as display that was previously marked as non-display with the DROP statement, use the RESET statement for that item. Note, however, that this will also reset the various attributes of that item to their default values (such as name, format, and so on).

Chapter Contents
Previous
Next
Top of Page