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 System Options: Reference.