The DBLOAD Procedure

WHERE Statement

Loads a subset of observations into the PC file.
Restriction: An editing statement, such as WHERE, must be specified after the database-description statements when you create and load a PC File.
See: SAS Statements: Reference

Syntax

WHERE SAS-where-expression;

Details

The SAS where-expression must be a valid statement that uses SAS variable names (not column names) as defined in the input data set.

Example

The WHERE statement loads only the observations where the SAS variable Country has the value Brazil.
WHERE country='Brazil';