This article describes how to go from a crosstab or summary grid table...
...to a table that displays the rank based on the cell percentages. In this example, we are ranking the brand attributes for each cola:
To convert the crosstab to a table of ranks:
- Right-click on your Report tree and select Add R Output.
- Paste the following code in the Properties > R CODE box and change the second line to the table you’d like to convert to rankings. If you are applying these steps to your own data step, assign x to the reference name of the crosstab you want to convert. This can be done by right-clicking the table in the Report tree and selecting Reference name…
# specify the table
x = table.q5
# make data negative (the rank function ranks smallest number as 1)
x = x*-1
# apply the ranking
ranks = apply(x,1,rank,"average")
# transpose the result back to the original format
table.rank = t(ranks)
If you’d like to create the ranks within each column instead of each row, change line 8 to the following: ranks = apply(x,2, rank, ”average”)Check Automatic to allow the R table to automatically update with your data.
Check Automatic to allow the R table to automatically update with your data.
The end result is an R output table with the brand attributes ranked for each type of cola.