Hi, I would like to rank 10 variables for each case separately, with the new variablenames to be 1 for the highest, 2 for the second highest. How do i do it?
Data looks something like this:
Cases -- A B C D E F G H I J ---- 1 2 3 4 5 6 7 8 9 10
1------- 2 6 4 3 1 8 7 9 10 5 ---- 10 9 8 7 6 5 4 3 2 1
2------- 7 5 4 8 10 3 2 1 6 9 ---- 10 9 8 7 6 5 4 3 2 1
3

You could use something like this:


FLIP
VARIABLES=Cases A B C D E F G H I J .

SORT CASES BY
var001 (D) .

FLIP
VARIABLES=var001.


Obviously, this will solve just the first case of the file. You'll need to do a loop to the others. And you'll need to rename the new variables.