REUSE= Data Set Option

Specifies whether new observations can be written to available space in compressed SAS data sets.

Valid in: DATA step and PROC steps
Category: Data Set Control
Restriction: Use with output data sets only.
Syntax
Syntax Description
Details
See Also

Syntax

REUSE=NO | YES

Syntax Description

NO

does not track and reuse space in compressed data sets. New observations are appended to the existing data set. Specifying the NO argument results in less efficient data storage if you delete or update many observations in the SAS data set.

You can use procedures such as APPEND and FSEDIT that add observations to the end of SAS data sets with compressed data sets.

YES

tracks and reuses space in compressed SAS data sets. New observations are inserted in the space that is available when other observations are updated or deleted.

REUSE=YES causes new observations to be added wherever there is space in the file, not necessarily at the end of the file.

Details

By default, new observations are appended to existing compressed data sets. To track and reuse available space by deleting or updating other observations, use the REUSE= data set option when you create a compressed SAS data set.
Use REUSE= only when you are creating new data sets with the COMPRESS=YES data set option or system option.
The REUSE= data set option overrides the REUSE= system option.
REUSE=YES takes precedence over POINTOBS=YES. For example, the following statement results in a data set that has POINTOBS=NO: 
data test(compress=yes pointobs=yes reuse=yes);
Because POINTOBS=YES is the default when you use compression, REUSE=YES causes POINTOBS= to change to NO.

See Also

Data Set Options:
COMPRESS= Data Set Option
System Options:
REUSE= System Option in SAS System Options: Reference
Copyright © SAS Institute Inc. All Rights Reserved.