ACCESS Procedure Reference

RESET Statement

Resets specified or all items to their default settings.

Optional statement
Applies to:	access descriptor or view descriptor

Syntax
Details
	Access descriptors
	View descriptors
Arguments

Syntax

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

Details

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 will be 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.

Arguments

The following list explains the arguments that appear in the RESET statement:

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.

Top of Page