proq sql; Select * from class where score =(select max(score) from class

How to get top scorer student from a class-table having
different sections A,B, C & D? Each section having same
number of students.

Question Posted / aloor

Answer Posted / aloor

proq sql;
Select * from class where score =(select max(score) from
class);
quit;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is PDV?

1150

what is the difference between unique key and primary key? : Sas-di

1130

what can you learn from the sas log when debugging? : Sas programming

1087

In SAS explain which statement does not perform automatic conversions in comparisons?

1312

what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

1014

Explain how merging helps to combine data sets.

1054

How you can read the variables that you need?

1125

What are the data types that sas contain?

1183

what is null hypothesis? why do you consider that?

2897

Explain data step in SAS

1098

Explain how you can debug and test your SAS program?

1013

What does the RUN statement do?

1304

Tell e how how dealt with..

2226

Mention few capabilities of sas framework.

1182

Name any two sas spawners? : sas-grid-administration

1039