|
|
Dear all,
For each of my cases, I would like to compute 4 new variables, those being the medians across respectively:
- a set of 4 variables (q17 TO q41). Their valid values range from 1 to 3.
- a set of 166 variables (q19a TO q81g) . Their valid values range from 1 to 4.
- a set of 31 variables (q55 TO q76y). Their valid values range from 1 to 5.
- a set of 10 variables (LADDSCH TO LADDAUS). Their valid values range from 1 to 10.
In my data set, all those variables are already placed one after the other. There are all numeric (ordinal level). Some cases have many missing values. The missing values are encoded as "99", "88", "77", and "0".
I started to ask SPSS to split the file per case. But then SPSS (version 14) apparently has a function for the MEAN but none for the median under COMPUTE so that's only how far I got!
Thanks for any hint,
Regards,
Aude
|
Locked
