I am working with a very big data set in SPSS. I am trying to transform 7 variables into 1. I figured out that the mode would be more represenative than the mean for this particular case but it is not offer in the functions of the "compute variables" option. I don't want to do it by hand. The values are only 1 to 3.
If it is not possible to do, I was wondering if I was changing each number by bigger ones and doing the sum accross the variables, I could maybe figure out which number came the more often and apply a rule of selection.... But I didn't think of this thoroughly and if someone knows a way to do this faster, I would really appreciate.