how to select out the valid cases without missing data, using listwise deletion

[zencaroline]

Hello,

At your possible convenience, might anyone please kindly answer my
question? Thank you very much.
I have 2232 cases. 232 cases have missing data. So, I would like
to use listwise deletion to remove the 232 cases from further
analysis. That is, I want to get (create) a data file with only cases
having complete data, i.e., valid 2000 cases.
Might anyone please kindly tell me how to do it in SPSS or EXCEL?
How to get a file with only valid 2000 cases, without the 232
cases that have missing data?
Thank you very much.
Please take care
Caroline

 

[Roger Govier]

Hi

Difficult to advise without more information.
If you are saying you have 2232 rows of data, where not all columns have
been completed, then one way would be to add a further column to the right
of your data.
Supposing there should be 15 columns of data filled in, enter
=IF(COUNTA(A1:O1)<15,0,1)

Now, use Data>Filter>Autofilter and filter on the new column for 1