topic Re: SAS in SAS Programming

Find the third highest value from each group

nayab_shaik — Wed, 29 May 2019 16:26:44 GMT

Hi Team,

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

Re: SAS

Kurt_Bremser — Wed, 29 May 2019 14:40:33 GMT

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.

Re: SAS

PaigeMiller — Wed, 29 May 2019 14:44:02 GMT

@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"?

Re: SAS

anushreebiotech — Wed, 29 May 2019 15:05:55 GMT

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

Re: SAS

ghosh — Wed, 29 May 2019 15:27:44 GMT

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?