Create a new column in an output worksheet by ranking columns in the source worksheet in ascending or descending order and sorting them based on the Group By selections.
Use one of the following to add the worksheet object to a Workflow:
Right-click menu for a Workflow object: New > Data Management > Rank Worksheet.
Main menu: Insert > Data Management > Rank Worksheet.
Right-click menu for a worksheet: Send To > Data Management > Rank Worksheet.
To view the object in its own window, select it in the Object Browser and double-click it or press ENTER. All instructions for setting up and execution are the same whether the object is viewed in its own window or in Phoenix view.
Mappings panels identify how input variables are to be used. Map the data by dragging the dataset from the Data folder to the Setup tab or use the 
icon in the Setup tab.
Once a dataset is mapped, use the option buttons in the Mappings panels to assign the columns in the dataset to the appropriate context associations. Required context mappings are colored orange.
Group By: Phoenix generates a separate set of ranking values for each unique value or group of values in columns mapped to the Group By context.
Rank: Parameters or variables mapped to Rank are ranked in ascending or descending order.
Any study variable or parameter mapped to the Group By context acts as a sort key in the output worksheet. If enough data types are mapped to Group By to create individual profiles for each rank, then the ranking column values never go above one.
Data types mapped to Rank are ranked either numerically or alphabetically, depending on the data contained in the column.
If there are no matching values in a column mapped to the Rank context, and one or no columns are mapped to Group By, then the ranking count is incremented by one.
For every matching value in any column mapped to the Rank context, the ranking count is incremented by 0.5 for every N+1 matching values. For example, if the ranked column starts with two matching values, then the ranking for the first two values is 1.5 and 1.5. If the ranked column starts with three matching values the ranking is 2, 2, and 2. If there are four the ranking is 2.5, 2.5, 2.5, and 2.5.
When matching values are encountered, the normal incrementation by one is stopped, the matching values are given equal ranking numbers, and the incrementation resumes normally with the next non-matching value.
In the New Column Name field, type a name for the ranking column.
The ranking column ranks the data types mapped to Rank in incremental order based on how many unique values are in the ranked data.
In the Sort Direction menu, select an ascending or descending sort direction for the rank column.
Select the Results tab to view the output. The object generates one worksheet and one text file.
Ranked: The ranked values, in ascending or descending order (arranged alphabetically or numerically based on the first selected sort key).
Settings: Text file containing input worksheets used and the options selected.