proc rank data=emp descending ties=dense out=s(where=(inc=1)); by deptno ;

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 / partha

Answer Posted / partha

proc rank data=emp descending ties=dense out=s(where=(inc=1));
by deptno ;
var sal;
ranks inc;
run;
quit;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How we can call macros with in data step? : sas-macro

1120

What is a macro routine?

2714

explain the main difference between the nodup and nodupkey options? : Sas-administrator

1160

what do the pad and dim functions do? : Sas programming

1017

Describe the ways in which you can create macro variables?

1189

How can sas program be validated?

1032

What are the prime responsibilities of data integration administrator? : Sas-di

1063

what are the types of interactive display types? : Sas-bi

1092

how do the in= variables improve the capability of a merge? : Sas programming

1434

How substr function works in sas?

1222

Mention some common errors that are usually committed in sas programming.

1042

how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2752

what is the difference between infile and input? : Sas-administrator

1136

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

1287

What are the data types that sas contain?

1174