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 / chandu
DATA ONR;
INPUT
@1 a
@3 b
@5 c
@7 d
;
SUM_VALUE =SUM (A, B, C, D);
RUN;
PROC SORT DATA=ONE NODUPKEY;
BY SUM_VALUE;
RUN;
DATA ONE_RESULT;
SET SUM;
IF _N_ = 2 THEN OUTPUT;
RUN;
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is by-group processing?
What do you code to create a macro? : sas-macro
how to debug and test the sas program? : Sas-administrator
Name any two sas spawners? : sas-grid-administration
how can you create zero observation dataset? : Sas programming
Explain the purpose of retain statement.
What is the length assigned to the target variable by the scan function?
how will you locate the sas platform applications? : Sas-bi
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
What is the use of PROC gplot?
explain the key concept of sas? : Sas-administrator
How many ways to overcome a missing values???
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
What is the use of %include statement?
what is snowflake schema? : Sas-di