Ranks all values in a column based on the method chosen
Function:
Rank(table = string, col = string, new_col = string, method = string)
Parameters:
Table: Table name on which to perform function
Column (col): Column to perform Rank
Method: How to rank the group of records that have the same value,
- first: ranks assigned in order they appear,
- min: will rank values as the same
New Column Name: Name for New Column
Examples:
Rank(table = Budget, col = "Amount", new_col = "Amt. Ranked", method = "first")