DOWNLOAD Procedure
WHERE Statement
Selects observations from SAS data sets.
Restriction: 
The DOWNLOAD procedure processes WHERE statements when
you transfer a single SAS data set.

See: 
SAS Statements: Reference .

Syntax
WHERE whereexpression1 <logicaloperator whereexpressionn>;
Required Arguments
 whereexpression1

is a WHERE expression.
 logicaloperator

is one of the following
logical operators:
 whereexpressionn

is a WHERE expression.
To understand when
using the SUBSTR function causes an index to be used, look at the
format of the SUBSTR function in a WHERE statement:
where substr(variable, position, length)
= 'characterstring';
An index is used in
processing when all of the following conditions are met:


length is less than or equal to the length of
variable

length is equal to the length of
characterstring
The following example
illustrates using a WHERE statement with the DOWNLOAD procedure. The
downloaded data set contains only the observations that meet the WHERE
condition.
proc download data=revenue out=new;
where origin='Atlanta' and revenue < 10000;
run;
Copyright © SAS Institute Inc. All rights reserved.