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;
The 2025 SAS Hackathon has begun!
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.