Select data

[pailek1996]

Hi guys, I am required to produce output like the image sample from the fitness data set. May I know the solutions? The questions is like: What is the highest runtime for male and female individuals in the fitness data file? 

[kiranv_ · Accepted solution]

something like this

 title  'max runtime for female';
 proc sql;
 select max(runtime) as mxdata from sashelp.class
 where sex= 'F';
title;
 title  'max runtime for Male'; 
select max(runtime) as mxdata from sashelp.class
 where sex= 'M';
 quit;

[pailek1996]

May i know, how can i get the "Obs" as the image shown.

[kiranv_]

proc sql number;

select max(runtime) as mxdata from sashelp.class

where sex= 'F';

title;

title 'max runtime for Male';

select max(runtime) as mxdata from sashelp.class

where sex= 'M';

quit;

but this shows up as ROW instead of obs as heading or use SAS undocumented function monotonic() as shown below

proc sql ;

select monotonic() as Obs, max(runtime) as mxdata from sashelp.class

where sex= 'F';

title;

title 'max runtime for Male';

select monotonic() as Obs, max(runtime) as mxdata from sashelp.class

where sex= 'M';

quit;

[pailek1996]

Thanks so much! This the solution I am looking for, much appreciated!

[Jagadishkatam]

alternatively try the proc means

proc means data=have nway;
class sex;
var runtime;
output out=want max=max;
run;