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;

Argument

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:

The word Subset appears in parentheses following the FSVIEW window title to indicate that a permanent WHERE clause is in effect.
Observation numbers might not be sequential because some observations might be excluded.
You cannot use the SORT command to sort the displayed observations.
You cannot scroll a particular observation to the top of the FSVIEW window by typing the corresponding observation number on the command line.

Top of Page