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
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;
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.