DBKEY

Improves performance for a join with a large source table and a small SAS data set (specifies a column to use as an index).
Valid in: DATA and PROC steps (when accessing PC files data using SAS/ACCESS software)
Default: none

Syntax

DBKEY=<('column-1' ... 'column-n')>

Syntax Description

column
is the name of the column that forms the index on the data source table.

Details

When processing a join that involves a large data source table and a relatively small SAS data set, you might be able to use DBKEY to improve performance.
CAUTION:
Improper use of this option can harm performance.