LIBNAME Statement: PC Files on Microsoft Windows

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 value:	none

Syntax
Syntax Description
Details

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.

Top of Page

Previous Page
|
Next Page
|
Top of Page