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

how can you create zero observation dataset? : Sas programming

1101

What are the scrubbing procedures in sas?

962

what are 5 ways to perform a table lookup in sas? : Sas-administrator

1194

What is the order of application for output data set options, input data set options and SAS statements?

1511

Which are the statements whose placement in the data step is critical?

1203

explain what is data set in sas? : Sas-administrator

928

Explain data_null_?

1010

what is transformation in sas data integration? : Sas-di

984

How long can a macro variable be? A token? : sas-macro

1168

Mention the difference between ceil and floor functions in sas?

1113

Can you suggest us materials for sdtm mapping?

4395

Define run-group processing?

995

Give some examples where proc report’s defaults are same as proc print’s defaults?

1063

How would you identify a macro variable? : sas-macro

977

what are the best practices to process the large data sets in sas programming? : Sas-administrator

977