Delete Rows with number of missing values satisfying this expression (use keyword NMISS)

Use this option to delete rows in which the number of missing values meets the specified criteria.

The expression entered in this field must include the key term NMISS and have the appropriate syntax. Valid expressions include:

•

NMISS GT xx, which instructs the process to eliminate rows in which the number of missing values is greater than some number xx,

•

NMISS LT xx, which instructs the process to eliminate rows in which the number of missing values is less than some number xx, and

•

NMISS EQ xx, which instructs the process to eliminate rows in which the number of missing values is equal to some number xx.

The number xx is some whole number that you specify in the statement.

To Specify an Expression for Filtering Rows:

8

Type the desired filtering expression in the text box.

Example: To eliminate rows in which the number of missing values exceeds 5, type NMISS GT 5 in the text box, as shown below:

8

If you change your mind and would like to reset the field, click Clear.