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 sas and what are the functions? : Sas-administrator
what techniques and/or procs do you use for tables? : Sas programming
What is maximum storage capability of SAS?
How do you convert basic cube to transaction cube and transaction cube to basic cube?
Where do you use proc means over proc freq?
Hi, If anyone has base SAS certification dumps, please share.
what is program data vector? : Sas-administrator
What are the prime responsibilities of data integration administrator? : Sas-di
Name any two sas spawners? : sas-grid-administration
explain the main difference between the nodup and nodupkey options? : Sas-administrator
Mention the category in which sas informats are placed?
Are you involved in writing the inferential analysis plan? Tables specfications?
how does sas handle missing values in assignment statements? : Sas programming
How many ways to overcome a missing values???
Explain the main difference between the sas procedures and functions? : Sas-administrator