SPSS Tutorials

BASICS REGRESSION T-TEST ANOVA CORRELATION

SPSS SELECT IF – A Quick 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 shown below.

SELECT IF V1 = 1.

SPSS Select If - Real World 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 – What and Why?

Next tutorial: SPSS SPLIT FILE Command

Let me know what you think!

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

This tutorial has 7 comments