[b]SAS equivalent to MS Excel RANK function[/b]

[Starbury]

Is there a SAS equivalent to the RANK function in MS Excel>

 

[klaz2002]

There is a PROC RANK is that what you need?

 

[Starbury]

Well, that does it for me, but I want put the results back into the data step.

GOAL:
Var A is 613 unique observations.
Var B is a the rank of the Var A
Var C = 490th highest value of Var A
Var D = If Var B<=410th highest value of Var A Then (C-A) Else 0;

Var A is dependent on previously unmentioned variables, so I want the rankings to update as the other underlying variables change. Accordingly, I want Var D to change instantanesouly when program is run.

 

[ChrisW75]

You'll have to run it through a couple of steps. Use proc Rank to create Var B, then subsequent processing can fix up Var C and D.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.