proc sql; select max(score) < (select max(score) from table) from ta

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

Question Posted / maddy

Answer Posted / maddy

proc sql;
select max(score) < (select max(score) from table)

from table;
quit;

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What was the last computer book you purchased? Why?

2370

What is slibref?

1272

why is sas considered self-documenting? : Sas programming

1144

What is the purpose of _character_ and _numeric_?

1061

How to specify variables to be processed by the freq procedure?

1069

how will you location sas platform applications available from web browser? : Sas-bi

1071

Have you used macros? For what purpose you have used? : sas-macro

1038

What is the difference between INPUT and INFILE ?

1313

Define run-group processing?

1035

Explain what is data step?

1197

What is the difference between proportion and average?

3331

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3585

how does sas handle missing values in sort order? : Sas programming

915

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

986

what is the difference between floor and ceil functions in sas? : Sas-administrator

1252