FILTER

FILTER is used to exclude cases from program procedures without deleting them from the active dataset. When FILTER is in effect, cases with a zero or missing value for the specified variable are not used in program procedures. Those cases are not actually deleted and are available again if the filter is turned off.

FILTER  {BY var}
        {OFF   }

This command takes effect immediately. It does not read the active dataset or execute pending transformations. See the topic Command Order for more information.

Syntax for the FILTER command can be generated from the Select cases dialog by selecting If condition is satisfied or Use filter variable.

Example

FILTER BY SEX.
FREQUENCIES BONUS.