first thanks for your kindly help
here is the problem we encountered. We have 3 different variables( let's say A,B,C) for every cases , and we want to create a new variable (let's say V1 )that classifies different cases according to whether the case score highest in A,B,or C and sort them accordingly.
(for example, if case1 have A=1 B=2 C=1 , then the case belongs to B, and in V1, it will be B)
(another example, if case2 have A=4 B=2 C=2 , then the case belongs to A, and in V1, it will be A)
is there a way to create that variable effectively? we tried compare mean ,but it only generate a new table ,not a variable