LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows |
Improves performance by specifying a column to use as an index
when you process a join that involves a large data source table and a small
SAS data set.
Valid in: |
DATA and PROC steps
|
Default value: |
none
|
DBKEY=<('column-1'>...<'column-n')>
|
- column
-
is the name of the column that forms the index on the data
source table.
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. ![[cautionend]](../../../../common/63294/HTML/default/images/cautend.gif)
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.