FAQ/summiss - CBU statistics Wiki

Please enter your password of your account at the remote wiki below.
/!\ You should trust both wikis because the password could be read by the particular administrators.

Clear message
location: FAQ / summiss

Summing partially missing cases in SPSS

The default for obtaining sums and means in SPSS is to work them out only for cases with complete data.

To sum over cases, with at least x complete variable values in SPSS, we use the function, sum.x. Similarly to obtain the mean for cases, with at least x complete variable values, we use mean.x. e.g. 

compute scoresum   =  sum.3(a,b,c).
compute scoremn     =  mean.2(a,b,c).
exe.

scoresum will return missing for cases with <3 non-missing values. Ie any non-missing a, b and c. scoremn will return missing for cases with <2 non-missing values, ie having two or three missing values of any of variables a or b or c.