WHERE

WHERE

Loads a subset of data into the new table.

Optional statement

Syntax
Details

Syntax

WHERE SAS-where-expression;

Details

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. The following example loads only the observations in which the SAS variable COUNTRY has the value Brazil.

   where country='Brazil';

For more information on the syntax of the SAS WHERE statement, see SAS Language Reference: Dictionary.

An editing statement, such as WHERE, must be specified after the database connection statements when you create and load a DBMS table. See LOAD for more information.

Chapter Contents
Previous
Next
Top of Page