East Carolina University
Department of Psychology


Deleting Cases With Missing Data

      You want to delete from your SPSS data file all cases that have missing values on some variable.  Here is an easy way to do it.  Open a syntax window and past this syntax into it:

filter off.
use all.
select if(not missing(VariableName)).
execute.
 

    Of course you should replace "VariableName" with the name of the variable before you click Run.

birds flying

Return to SPSS LessonsClick here to return to Dr. Wuensch's SPSS Lessons Page.

Spider in web
Contact Information for the Webmaster,
Dr. Karl L. Wuensch


This page most recently revised on 9. November 2007.