RESET Statement

Resets specified or all items to their default settings.

Type: Optional statement
Applies to: access descriptor or view descriptor

Syntax

RESET ALL | item-name | index-number
<… item-name-n | index-number-n> ;

Required Arguments

ALL

resets all the items defined in the access descriptor to their default setting. For a view descriptor, the ALL option resets only the items that are selected.

item-name

specifies the name of the item that you want to reset. If you specify a record or group name, all the items in that record or group are reset.

index-number

specifies the index number of the item that you want to reset. The index number represents the item's place in the access descriptor. You can get the index number of an item using the LIST statement described earlier in this section. If you specify a record or group index number, all the items in that record or group are reset.

Details

Reset Items to Default Settings

The RESET statement resets specified or all items to their default settings. You can reset as many items as necessary using one RESET statement or the ALL option to reset all the items. The RESET statement has different effects on access and view descriptors.

Access Descriptors

In access descriptors, the default setting for a SAS variable name is a blank unless you included the AN= statement. If you used the AN= statement, the names are reset to those generated. The default setting for SAS formats in access descriptors is determined by the DB Formats of the items. Any dropped items are included again.

View Descriptors

In view descriptors, the RESET statement deselects items and resets the SAS name and format values to those defined in the access descriptor on which the view descriptor is based. The SAS names and formats are unaffected by the RESET statement if you specified the AN= statement with a value of Y when you created the access descriptor on which this view descriptor is based.