| The LIBNAME Statement for PC Files on Microsoft Windows |
Specifies criteria for subsetting and ordering data.
| Valid in: |
DATA and PROC steps (when accessing PC files
data using SAS/ACCESS software)
|
| Default value: |
none
|
|
DBCONDITION="SQL-query-clause"
|
-
SQL-query-clause
-
is a data source-specific SQL query clause,
such as WHERE, GROUP BY, HAVING, or ORDER BY.
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=.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
