| LIBNAME Statement: PC Files on Microsoft Windows |
Improves performance for a join with a large data 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 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/62850/HTML/default/images/cautend.gif)
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
