IDGROUP in proc summary

[Jaheuk]

dear all,

code below gives the name of the oldest person per group.

but for F we have 2 with the same age!  HOW to get the equal values?

proc summary data=sashelp.class nway missing  ;

     class sex;

     output out=WORK(drop=_:)      

          idgroup(max(age) out(age name)=mage name );

run;

proc print;

run;

i.e. we can get top 3 with this code, but that is not what i mean :smileyblush:

  proc summary data=sashelp.class nway missing  ; 

class sex; 

output out=WORK(drop=_:)       

idgroup(max(age) out[3](age name)=mage name ); 

run; 

proc print; 

run;

GreetZ,

Herman

[Keith · Accepted solution]

The CLASS statement in Proc Summary (or Means) will only return one value per group.  To get what you want you can use sql.

proc sql;

select sex, age, name

from sashelp.class

group by sex

having age=max(age);

quit;