ACCESS Procedure Reference

RESET Statement (Optional)

Re-sets specified or all items to their default settings.

Applies to:

access descriptors and view descriptors

Syntax

RESET ALL|variable-identifier <...variable-identifier-n>;

Details

The RESET statement re-sets the specified items or all the items to their default values.

When creating an access descriptor, the default setting for a SAS variable name is a blank, unless you specify SAS variable names using the RENAME statement or include the ASSIGN=YES statement. When using the RESET statement, the SAS variable names can be re-set to the default name generated by PROC ACCESS (that is, the first eight characters of the variable name) or to a blank. Items dropped by using a DROP statement also become available and can be selected in view descriptors that are based on this access descriptor.

When creating a view descriptor, the results are based on the setting of the ASSIGN statement in the access descriptor from which the view descriptor is derived. If ASSIGN=YES, the RESET statement cannot be used in the view descriptor. If ASSIGN=NO and if you re-set SAS variable names and variable attributes and select them later within the same procedure execution, the SAS variable names and attributes are re-set to the default values generated from the item names and data types. In a view descriptor, the RESET statement clears any items specified in the SELECT statement.

You can use one or more of the following in the RESET statement:

ALL: re-sets all the database items defined in the access descriptor to their default names and attribute settings. When creating a view descriptor, ALL re-sets all the items that have been selected, so that no items are selected for the view. You can use the SELECT statement to select new items. For more information, see the SELECT statement.

variable-identifier can be one of the following:

the current SAS name
the positional equivalent, which is the number that represents the item, as specified in the LIST statement
the SYSTEM 2000 C-number of the database item

For example, if you want to re-set the SAS variable name and attribute associated with the third item, submit the following statement:

reset 3;

Top of Page