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.

Answer Posted / maddy

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

from table;
quit;

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you delete duplicate observations in sas?

670


If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

700


Differentiate input and infile.

694


what is sas olap server? : Sas-di

814


What is the general format of function in sas? : sas-grid-administration

651






hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

5023


What is the difference between class statement and by statement in proc means?

761


What makes sas stand out to be the best over other data analytics tools?

677


What are the parameters of scan function?

730


If a variable contains only numbers, can it be a character data type?

724


Mention what is the difference between nodupkey and nodup options?

687


what is snowflake schema? : Sas-di

788


what do the mod and int function do? What do the pad and dim functions do? : Sas programming

739


please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

1773


Are you involved in writing the inferential analysis plan? Tables specfications?

1844