WHERE Statement (Optional)

Subsets input data

Applies to:

New and existing databases

Syntax

WHERE SAS-where-expression;

The WHERE statement specifies how you want to subset your input data.

SAS-where-expression must be a valid WHERE statement in SAS.

Note: You must use SAS variable names in the WHERE statement; do not use the SYSTEM 2000 component names.

The following statement loads only those observations that contain JONES and APRIL in the SAS variable CUSTNAME:

     where custname='JONES, APRIL';

For information about the WHERE statement in SAS, see SAS Statements: Reference.