topic Re: Select data in SAS Data Science

Select data

pailek1996 — Mon, 12 Jun 2017 16:57:05 GMT

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?

Re: Select data

kiranv_ — Mon, 12 Jun 2017 17:07:36 GMT

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;

Re: Select data

Jagadishkatam — Mon, 12 Jun 2017 17:19:03 GMT

alternatively try the proc means

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

Re: Select data

pailek1996 — Mon, 12 Jun 2017 17:35:11 GMT

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

Re: Select data

kiranv_ — Mon, 12 Jun 2017 17:51:15 GMT

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;

Re: Select data

pailek1996 — Mon, 12 Jun 2017 17:59:03 GMT

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