LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows

DBKEY

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

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