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 / wkm
proc sort data=table;
by section descending score;
run;
data table2;
retain tot 0;
set table;
by section descending score;
if first.section then tot=1;
tot+1;
if tot=2;
run;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the different operating system platforms in which we can use sas? : sas-grid-administration
what is the purpose of _error_? : Sas programming
How to limit decimal places for variable using proc means?
Explain bmdp procedure?
How do dates work in sas?
what is the difference between unique key and primary key? : Sas-di
how does sas handle missing values in a merge? : Sas programming
What is the function of output statement in a SAS Program?
What do you know about symput and symget?
What is the basic syntax of a sas program?
how can you put a "trace" in your program? : Sas programming
Name and describe few sas character functions that are used for data cleaning in brief.
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
for what purpose would you use the retain statement? : Sas programming
What does proc print, and proc contents are used for?