Filter to Include Tall Rows (and the corresponding Wide Variables)

The Filter to Include Tall Rows field is an optional parameter that enables you to filter columns of the wide data set based on variables in the Tall SAS Data Set. Only columns corresponding to rows that meet the condition(s) specified are included in the output.

For example, to include only rows from a data set containing a value greater than 100 for the spot variable, you could use the following simple WHERE expression:

WHERE spot > 100

Note: The word where has already been entered for you.

For more information about using filter fields, see The SAS WHERE Expression.