So i have data something like this in SPSS at the moment:
case 1: orange, bananas, mangoes
case 2: bananas, oranges, mangoes
So the first respondent ranked orange as best fruit whilst second ranked banana as the best fruit.
The variables i used were strings i.e. o, b and m, should this be a problem? Secondly, how do i assign rank to a particular column e.g. orange should be ranked 1 as it is in left most column, when the data was imported from sogosurvey ? See ranking.png for the actual dataAlso, is there a quick way to add replacement variable e.g. if the case has value "x" transform it to "yes" and if empty convert it to "no"? The empty cells mean not selected (=no OR 0) and M-multivariate course selected (=yes OR 1) in emptycells.png.Thanks for your help.