SPSS Tutorials

BASICS REGRESSION T-TEST ANOVA CORRELATION

SPSS SELECT IF – Simple Tutorial

In SPSS, SELECT IF deletes cases (rows of data) that don't satisfy some condition(s). Like so, SELECT IF basically means “don't delete if ...” A minimal example is SELECT IF(GENDER = 1).

SPSS SELECT IF - Some Examples

Say we collected data on our employees and the resulting data file is employees.sav. Our client is only interested in female respondents so we decide to delete all male respondents and those with missing values on gender. The syntax below demonstrates how to do so by using SELECT IF.

SPSS SELECT IF Syntax

*1. Delete all non female respondents.

select if gender ne 0.
exe.

Notes

Previous tutorial: SPSS FILTER – Simple Tutorial

Next tutorial: SPSS SPLIT FILE – A Quick Tutorial

Let me know what you think!

*Required field. Your comment will show up after approval from a moderator.

This tutorial has 15 comments