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

DBCONDITION

Specifies criteria for subsetting and ordering data.

Valid in:	DATA and PROC steps
Default value:	none

Syntax
Syntax Description
Details
See Also

Syntax

DBCONDITION=SQL-query-clause

Syntax Description

SQL-query-clause: is a data source-specific SQL query clause, such as WHERE, GROUP BY, HAVING, or ORDER BY.

Details

This option enables you to specify selection criteria in the form of data source-specific SQL query clauses, which the SAS/ACCESS engine passes directly to the data source for processing. When selection criteria are passed directly to the data source for processing, performance is often enhanced. The data source checks the criteria for syntax errors when it receives the SQL query.

The DBKEY= option is ignored when you use DBCONDITION= option.