ACCESS Procedure

RESET Statement

Resets DBMS columns to their default settings

Interaction:

ASSIGN, DROP, FORMAT, RENAME, SELECT

Syntax

Required Arguments

Details

Syntax

RESET ALL | <'>column-identifier-1<'> <…<'>column-identifier-n<'>>;

Required Arguments

ALL: resets all columns in an access descriptor to their default names and formats and reselects 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 quotation marks. For example, to reset the SAS variable name and format associated with the third column, submit this 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.

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, default names are the first eight characters of each DBMS column name.

For view descriptors, the RESET statement clears (deselects) any columns that were included in the SELECT statement. When you create a view descriptor that is based on an access descriptor that is created without an ASSIGN statement or with ASSIGN=NO, resetting and then reselecting (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.