Assigning Data to Roles

To run the Rank Data task, you must select an input data source. To filter the input data source, click Filter Icon

You must assign a column to the Columns to rank role.

Role	Description
Roles
Columns to rank	Each column that is assigned to this role is ranked. You must assign at least one variable to this role. By default, the rankings column is given the name rank_column-name, where column-name is the name of the original column.
Additional Roles
Rank by	When you assign one or more columns to this role, the input table is sorted by the selected column or columns and rankings are calculated within each group.
Output Data Set
Create new variables for the ranked variables	specifies that the output table contains the original columns as well as the ranked columns. If you want to replace the original column with the ranked columns, clear the Create new variables for the ranked variables check box. By default, the ranked column is given the name rank_column-name, where column-name is the name of the original column.
Show output data	specifies whether to display the output data set on the Results tab. You can choose to display all of the data or a subset of the output data. The task always creates an output data set that appears on the Output Data tab. The output data is also saved as a SAS data set.