topic Re: to find maximum marks using proc sql in New SAS User

to find maximum marks using proc sql

ashkum — Tue, 09 Oct 2018 05:53:58 GMT

data table_b;
infile datalines;
input std_id$ physics_mark;
datalines;
s001 73
s003 65
s004 52
s006 76
;
run;

I have to create new table which shows that maximum marks i.e only one observation so in that case soo6 has maximum marks. how do i use proc sql to find maximum marks.

Re: to find maximum marks using proc sql

Kurt_Bremser — Tue, 09 Oct 2018 06:23:04 GMT

proc sql;
select std_id, physics_mark
from table_b
having physics_mark = max(physics_mark);
quit;

Re: to find maximum marks using proc sql

singhsahab — Tue, 09 Oct 2018 16:35:05 GMT

Here you can go...

proc sql;
create table want as select * from table_b h where 0= (select count(physics_mark) from table_b h1 where h.physics_mark< h1.physics_mark);
quit;