| The DBLOAD Procedure for Relational Databases |
Loads a subset of data into the new
table
|
WHERE SAS-where-expression;
|
The WHERE statement causes a subset of observations
to be loaded into the new DBMS table. The SAS-where-expression must be a valid SAS WHERE statement that uses SAS variable
names (not DBMS column names) as defined in the input data set. This example
loads only the observations in which the SAS variable COUNTRY has the value BRAZIL.
where country='Brazil';
For more information about the syntax of the SAS WHERE
statement, see
SAS Language Reference: Dictionary.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
