DBLOAD Procedure

WHERE Statement

Loads a subset of data observations into the new table

See: SAS System Options: Reference (syntax)
Example: This example loads only the observations in which the COUNTRY SAS variable has the value of BRAZIL:
where country='Brazil';

Syntax

Required Argument

SAS-where-expression

specifies a valid SAS WHERE clause that uses SAS variable names, not DBMS column names, as specified in the input data set.

Last updated: February 3, 2026