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 has been your most common programming mistake? : Sas programming

1090

what is sas and what are the functions? : Sas-administrator

968

why a stop statement is needed for the point= option on a set statement?

1056

Differentiate input and infile.

1083

i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

2364

How would you identify a macro variable?

1078

how to change the execute of macro

2287

What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1772

What can you learn from the SAS log when debugging?

1357

what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

1077

How to read an input file in sas?

1125

What is the basic structure of a sas program?

1105

What is the difference between %local and %global? : sas-macro

1167

What would be the value of month at the end of data step execution and how many observations would be there?

1131

what are informats in sas? : Sas-administrator

1073