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.