Chapter Contents |
Previous |
Next |
RESET |
Optional statement | |
Applies to: | access descriptor or view descriptor |
Interacts with: | ASSIGN, CONTENT, DROP, FORMAT, INFORMAT, KEY, MVF, RENAME, SELECT |
Syntax | |
Details | |
Access descriptors | |
View descriptors |
Syntax |
RESET <ALL | column-identifier-1 <... column-identifier-n>>; |
Details |
If you use an editing statement, such as RESET, it must follow the CREATE statement and the database-description statements when you create a descriptor. See CREATE for more information on the order of statements.
Access descriptors |
When you create an access descriptor,
the default setting for a SAS variable name is a blank. However, if you have
previously entered or modified any of the SAS variable names, the RESET statement
resets the modified names to the default names that are generated by the ACCESS
procedure. How the default SAS variable names are set depends on whether you
included the ASSIGN statement. If you omitted ASSIGN or set it to
NO
,
the default names are blank. If you set
ASSIGN=YES
, the default
names are the first eight characters of each DBMS column name.
The current SAS variable format and informat are reset to the default SAS format and informat, which was determined from the column's data type. The current DB content, occurrence range, and BY key are also reset to the default values. Any columns that were previously dropped, that are specified in the RESET command, become available; they can be selected in view descriptors that are based on this access descriptor.
View descriptors |
When you create a view descriptor, the RESET statement clears any columns that were included in the SELECT statement (that is, it "de-selects" the columns).
When creating the view descriptor, if you reset a SAS
variable and then select it again within the same procedure execution, the
SAS variable name, format, informat, database content, occurrence range, and
BY key are reset to their default values, (the SAS name is generated from
the DBMS column name, and the format and informat values are generated from
the data type). This applies only if you have omitted the ASSIGN statement
or set the value to
NO
when you created the access descriptor
on which the view descriptor is based. If you specified
ASSIGN=YES
when you created the access descriptor, the RESET statement has no
effect on the view descriptor.
The RESET statement can take one of the following arguments:
For view descriptors, ALL resets all the columns that have been selected, so that no columns are selected for the view; you can then use the SELECT statement to select new columns.
reset 3;
If the column name contains special characters or national characters, enclose the name in quotes. You can reset as many columns as you want in one RESET statement, or use the ALL option to reset all the columns.
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.