IDGROUP in proc summary

Jaheuk — Fri, 19 Jul 2013 12:05:00 GMT

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

Re: IDGROUP in proc summary

Keith — Fri, 19 Jul 2013 12:48:34 GMT

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;