How to create a table of ranks from a crosstab

Introduction

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.