The RESET statement resets 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 reset 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 reset SAS variable names and variable attributes
and select them later within the same procedure execution, the SAS variable
names and attributes are reset 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
resets all the
database items defined in the access descriptor to their default names and attribute settings.
When creating a view descriptor, ALL resets 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 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 reset the SAS variable name and attribute associated with
the third item, submit the following statement:
reset 3;