DBCONDITION

Specifies criteria for subsetting and ordering data.
Valid in: DATA and PROC steps (when accessing PC files data using SAS/ACCESS software)
Default: none

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 option is ignored when you use DBCONDITION.

See Also