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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

934


Explain append procedure?

627


which features do you use to check the data validations and errors? : Sas-administrator

542


Describe the function and untility of the most difficult SAS macro that you have written.

1718


is data integration and etl programming is same? : Sas-di

570






Mention common programming errors committed in sas ?

640


What is connection profile? : sas-grid-administration

642


what is the use of proc contents and proc print in sas? : Sas-administrator

599


What is maximum storage capability of SAS?

900


Of all your work, where have you been the most successful?

4193


For what purpose would you use the RETAIN statement?

1036


Are you sensitive to code walk-throughs peer review or QC review?

2593


What is the basic structure of the SAS base program?

681


Describe what are the different levels of administrative users in sas? : sas-grid-administration

594


What are the different types of sas functions?

603