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 is PhaseIII, ODS, TLG, Macro and Proc in SAS
How do you use the do loop if you don’t know how many times you should execute the do loop?
what is SAS OPTIMIZATION?
What are the advantages of using sas?
What is the SAS data set?
How to test the debugging in sas?
What does the trace option do?
Differentiate between proc means and proc summary.
how do you test for missing values? : Sas programming
what is the use of sas management console? : Sas-di
what is change analysis in sas di ? : Sas-di
What is the use of the %include statement?
Give some examples where proc report’s defaults are different than proc print’s defaults?
What are symget and symput? : sas-macro
what is program data vector? : Sas-administrator