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.
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;