SAS VA Ranking

ashishj816 — Fri, 14 Dec 2018 07:48:08 GMT

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

Re: SAS VA Ranking

ballardw — Sat, 15 Dec 2018 00:15:03 GMT

@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;

topic Re: SAS VA Ranking in SAS Programming

SAS VA Ranking

Re: SAS VA Ranking