SAS VA Ranking

[ashishj816]

Hi All,

I want to show Ranking of Customer Based on Revenue.

I know that there is feature of SAS VA where we can select Rank based on which measure.

But I also want to show Rank number.

Ex:-

Customer Name	Rank	Revenue
C1	1	999
C2	2	998
C3	3	987
C4	4	986
C5	5	985

[ballardw]

---

@ashishj816 wrote:

Hi All,

I want to show Ranking of Customer Based on Revenue.

I know that there is feature of SAS VA where we can select Rank based on which measure.

But I also want to show Rank number.

Ex:-

Customer Name	Rank	Revenue
C1	1	999
C2	2	998
C3	3	987
C4	4	986
C5	5	985

---

Do you want to do this in VA or base programming code? You have posted this in an area that is intended for general programming, not VA.

This is a general programming solution using the Sashelp.class data set and ranking based on height.

proc rank data=sashelp.class
   out=work.classranked
   descending
;
   var height;
   ranks heightrank;
run;

proc sort data=work.classranked;
   by  heightrank;
run;