The ACCESS Procedure for Relational Databases SELECT Statement 305
RESET ALL |<’>column-identifier-1<’> <…<’>column-identifier-n<’>>;
ALL
resets all columns in an access descriptor to their default names and formats and
re-selects any dropped columns. ALL deselects all columns in a view descriptor so
that no columns are selected for the view.
column-identifier
can be either the DBMS column name or the positional equivalent from the LIST
statement, which is the number that represents the column’s place in the access
descriptor. If the column name contains lowercase characters, special characters, or
national characters, enclose the name in quotes. For example, to reset the SAS
variable name and format associated with the third column, submit the following
statement:
reset
3;
For access descriptors, the specified column is reset to its default name and format
settings. For view descriptors, the specified column is no longer selected for the view.
Details
The RESET statement resets column attributes to their default values. This
statement has different effects on access and view descriptors.
For access descriptors, the RESET statement resets the specified column names to
the default names that are generated by the ACCESS procedure. The RESET
statement also changes the current SAS variable format to the default SAS format. Any
previously-dropped columns that are specified in the RESET statement become
available.
Note: When creating an access descriptor, if you omit the ASSIGN statement or set
it to
NO, the default SAS variable names are blanks. If you set
ASSIGN=YES, the default
names are the first eight characters of each DBMS column name.
For view descriptors, the RESET statement clears any columns that were included in
the SELECT statement (that is, it "de-selects" the columns). When you create a view
descriptor that is based on an access descriptor created without an ASSIGN statement
or with
ASSIGN=NO, resetting and then re-selecting (within the same procedure
execution) a SAS variable changes the SAS variable names and formats to their default
values. When you create a view descriptor that is based on an access descriptor created
with
ASSIGN=YES, the RESET statement does not have this effect.
SELECT Statement
Selects DBMS columns for the view descriptor
Applies to: view descriptor
Interacts with: RESET
SELECT ALL |<’>column-identifier-1<’> <…<’>column-identifier-n <’>>;
