MODE= Data Set Option

Specifies whether to enable multiple performance-related options.

Valid in: DATA and PROC steps (when accessing data that is in an external data source)
Category: Data Set Control
Default: LIBNAME option value
Data source: Google BigQuery
Note: Support for this option was added in SAS 9.4M9. Support was added for SAS 9.4M8 in December 2025.
See: IGNORE_FEDSQL_OBJECTS= data set option, MODE= LIBNAME option, READ_MODE= data set option, SCANSTRINGCOLUMNS= data set option

Table of Contents

Syntax

Required Arguments

PERFORMANCE

specifies that you want to enable performance-related options.

STANDARD

specifies that you want to use default values for performance-related options.

Details

When you set MODE=PERFORMANCE, you automatically set the following values for these data set options:

  • IGNORE_FEDSQL_OBJECTS=YES
  • READ_MODE=STORAGE
  • SCANSTRINGCOLUMNS=YES

To override any of these values, explicitly specify that option and assign a different value. For example, if you specify MODE=PERFORMANCE and SCANSTRINGCOLUMNS=NO, then the SCANSTRINGCOLUMNS= data set option is disabled.

Last updated: February 3, 2026