Statements with the Same Function in Multiple Procedures

WHERE

Subsets the input data set by specifying certain conditions that each observation must meet before it is available for processing.

WHERE where-expression;

Required Arguments

where-expression: is a valid arithmetic or logical expression that generally consists of a sequence of operands and operators. See SAS Language Reference: Dictionary for more information on where processing.

Procedures That Support the WHERE Statement
You can use the WHERE statement with any of the following base SAS procedures that read a SAS data set:

CALENDAR RANK

CHART REPORT

COMPARE SORT

CORR SQL

DATASETS (APPEND statement) STANDARD

FORMS TABULATE

FREQ TIMEPLOT

MEANS/SUMMARY TRANSPOSE

PLOT UNIVARIATE

PRINT

Details

The CALENDAR and COMPARE procedures and the APPEND statement in PROC DATASETS accept more than one input data set. See the documentation for the specific procedure for more information.
To subset the output data set, use the WHERE= data set option:
```
proc report data=debate nowd
            out=onlyfr(where=(year='1'));
run;
```
For more information on WHERE=, see SAS Language Reference: Dictionary.

Example
In this example, PROC PRINT prints only those observations that meet the condition of the WHERE expression. The DEBATE data set is created in Example: Temporarily Dissociating a Format from a Variable .

   options nodate pageno=1 linesize=64 
           pagesize=40;

   proc print data=debate noobs;
      where gpa>3.5;
      title 'Team Members with a GPA'; 
      title2 'Greater than 3.5';
   run;

Chapter Contents
Previous
Next
Top of Page

CALENDAR		RANK
CHART		REPORT
COMPARE		SORT
CORR		SQL
DATASETS (APPEND statement)		STANDARD
FORMS		TABULATE
FREQ		TIMEPLOT
MEANS/SUMMARY		TRANSPOSE
PLOT		UNIVARIATE
PRINT