Find the third highest value from each group

[nayab_shaik]

Hi Team,

write sas code to find out 3rd max weight on each sex group wise from sashelp.class by using data step programming

[Kurt_Bremser]

Sort by sex and descending weight.

In a data step with

by sex;

use

if first.sex

to set a counter to 1, otherwise increment counter with

counter + 1;

Use a subsetting if

if counter = 3;

to only output the third observation for each group. I intentionally leave writing the whole code to you, so you have opportunity for learning.

[PaigeMiller]

@nayab_shaik it would be helpful to all of us if you could use meaningful titles for your posts, instead of "SAS". For example, could you please change the title of this thread to "Find 3rd highest in a group"?

[anushreebiotech]

Hi,

proc sort data= sashelp.class out= class_check;
by sex descending Weight ;
run;

data class_check2;
set class_check;
by sex descending Weight;
if first.sex then counter=0;
counter+1;
if counter=3 then output;
drop name age counter;
run;

Regards,

Anushree

[ghosh · Accepted solution]

proc sort data=sashelp.class out=class;
by  sex descending weight;
run;

proc rank data=class out=rank_3(where=(weight_rank=3)) descending;
by sex;
var weight;
ranks weight_rank;
run;

If there are ties, how would you like to resolve them?