LARGE_RESULTS_EXPIRATION_TIME= LIBNAME Statement Option

Specifies the amount of time in milliseconds until a temporary table is deleted.

Valid in: SAS/ACCESS LIBNAME statement
Category: Data Set Control
Alias: LRET=
Default: 86400000 (24 hours)
Range: 1 (see Details), 3600000–2147483647
Interaction: This option is used when the ALLOW_LARGE_RESULTS= LIBNAME option is enabled.
Data source: Google BigQuery
Note: Support for this option was added in the April 2021 update for SAS/ACCESS on SAS 9.4M7. Support was extended to SAS 9.4M8 and SAS 9.4M9 with the release of SAS 9.4M9.
See: ALLOW_LARGE_RESULTS= LIBNAME option, LARGE_RESULTS_DATASET= LIBNAME option

Table of Contents

Syntax

LARGE_RESULTS_EXPIRATION_TIME=milliseconds

Required Argument

milliseconds

specifies the amount of time in milliseconds before a temporary table is deleted.

Details

If you specify the special value 1, the table does not expire.

Last updated: February 3, 2026