I have input as
100
100
100
90
90
80
80
80
I want to give ranking for this as
100 1
100 1
100 1
90 2
90 2
80 3
80 3
Rank in DataStage
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Rank is a display function. Of course you could do it. But your output is wrong. It should be:
100 1
100 1
100 1
90 4
90 4
80 6
80 6
You can read about tied ranks in any nonparametric statistics textbook.
100 1
100 1
100 1
90 4
90 4
80 6
80 6
You can read about tied ranks in any nonparametric statistics textbook.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.