Chapter Contents |
Previous |
Next |
RESET |
Optional statement | |
Applies to: | access descriptor and view descriptor |
Syntax | |
Details |
Syntax |
RESET
ALL|variable-identifier
<...variable-identifier-n>; |
Details |
The RESET statement resets all or the specified items to their default values.
When creating an access descriptor, the default setting for a SAS variable name is a blank, unless you enter SAS variable names using the RENAME statement or include the ASSIGN=YES statement. Therefore, when using the RESET statement, the SAS variable names can be reset to the default name generated by the ACCESS procedure (that is, the first eight characters of the variable name) or to a blank. Items dropped with a DROP statement also become available and can be selected in view descriptors based on this access descriptor.
When creating a view descriptor, the results depend on the setting of the ASSIGN statement in the access descriptor on which the view descriptor is based. If ASSIGN=Y, the RESET statement cannot be used in the view descriptor. If ASSIGN=NO, if you reset SAS variable names and variable attributes and then 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 (that is, it unselects the items).
The RESET statement can take one or more of the following arguments:
ALL | resets all the database items defined in the access descriptor to their default name and attribute settings. When creating a view descriptor, the ALL argument resets all the items that have been selected, so that no items are selected for the view; you can then use the SELECT statement to select new items. See the SELECT statement later in this chapter for more information. |
variable-identifier | can be the current SAS name, the
positional equivalent (which is the number that represents the item as given
by the LIST statement), or the SYSTEM 2000 component number of the database
item.
For example, if you want to reset the SAS variable name and attribute associated with the third item, issue the following statement: reset 3; |
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.