Chapter Contents


The FSVIEW Procedure

WHERE Statement

Defines criteria that observations in the input data set must meet in order to be displayed by the procedure.

Reminder: The WHERE statement is ignored if you use the NEW= option in the PROC FSVIEW statement.

WHERE expression;


expression is any valid WHERE expression that includes one or more of the variables in the input data set. Refer to the description of the WHERE statement in SAS Language Reference: Dictionary for details about the operators and operands that are valid in WHERE expressions.

Using the WHERE Statement

By default, the FSVIEW procedure displays all the observations in the data set. The WHERE statement is useful when you want to view only a subset of the observations in a SAS data set. For example, to view only observations for which the value of the variable YEAR is less than 5, follow the PROC FSVIEW statement with this statement:

where year<5;

The FSVIEW procedure displays only observations that meet the specified condition(s). Observations that do not satisfy the condition(s) are not shown and cannot be edited.

Conditions that are imposed by a WHERE statement (or, equivalently, by a WHERE= data set option) are called permanent WHERE clauses because they remain in effect for the duration of the FSVIEW session and cannot be canceled or modified while the procedure is active.

When you use a WHERE statement in conjunction with the PROC FSVIEW statement, the behavior of the FSVIEW procedure is affected in the following ways:

Chapter Contents



Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.