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

do you need to know if there are any missing values? : Sas programming

988

What is the difference between where and if statement?

1060

what is the Population you used in your project, is it ITT or PP?

2680

What are the parameters of scan function?

1107

This entry was posted in General. Bookmark the permalink. Post a comment or leave

4527

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

1058

What is the basic structure of a sas program?

1057

Difference between SAS STATA & SPSS?

1059

What is the role of sas grid administrator? : sas-grid-administration

1233

what is factor analysis? : Sas-administrator

1028

Why and when do you use proc sql?

1181

What are the statements that are executed only?

1095

what is the basic structure sas administrator? : Sas-administrator

956

Give some examples where proc report’s defaults are different than proc print’s defaults?

1011

I have a dataset concat having variable a b & c. How to rename a b to e & f?

962