The ACCESS Procedure for PC Files

RESET Statement

Resets PC file columns to their default settings.

Valid:	for DBF, DIF, WK1, WK3, WK4, Excel 4, Excel 5, and Excel 95 file formats under Windows operating environments
Applies to:	access descriptor or view descriptor
Interacts with:	ASSIGN, DROP, FORMAT, RENAME, SELECT
Not allowed with:	UPDATE

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

Details

The RESET statement resets either the attributes of all columns or the attributes of the specified columns to their default values. The RESET statement can be used when you create an access descriptor or a view descriptor, but it is not allowed when you are updating a descriptor. RESET has different effects on access and view descriptors, as described below.

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 the CREATE Statement.

The RESET statement can take one or more of these arguments:

ALL

for access descriptors, resets all PC file columns that are defined to their default names and format settings and re-selects any dropped columns.

For view descriptors, ALL resets all columns that are selected so that no columns are selected for the view. You can then use the SELECT statement to select new columns.

See the SELECT Statement.

column-identifier

can be either the column name or the positional equivalent from the LIST statement. This is the number that represents the column's place in the access descriptor. To reset the SAS variable name and format associated with the third column, submit this statement:

RESET 3;

If the column name contains lowercase characters, special characters, or national characters, enclose the name in quotation marks. Reset as many columns as you want in one RESET statement. The ALL option can also be used to reset all columns.

When creating an access descriptor, the column-identifier is reset to its default name and format settings. When creating a view descriptor, the specified column is no longer selected for the view.

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 PC file column name.

The current SAS variable format is also reset to the default SAS format, which was determined from the column's data type. Any columns that were previously dropped, but that are specified in the RESET statement, 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.

When creating the view descriptor, if you reset a SAS variable and select it again within the same procedure execution, the SAS variable names and formats are reset to their default values. The defaults are generated from the column names and data types. This applies only if you have omitted the ASSIGN statement or set the value to NO when you created the access descriptor.

If you specified ASSIGN=YES when you created the access descriptor, the RESET statement has no effect on the view descriptor.

Top of Page