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 the role of sas grid administrator? : sas-grid-administration
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
How do dates work in SAS data?
how could you generate test data with no input data? : Sas programming
what is the difference between nodup and nodupkey options? : Sas programming
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
what is data governance? : Sas-di
Mention how to limit decimal places for the variable using proc means?
Difference between SAS STATA & SPSS?
Describe the function and utility of the most difficult SAS macro that you have written?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
If a variable contains letters or special characters, can it be numeric data type?
What are the scrubbing procedures in sas?
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
What do you know about sas and what we do? : sas-grid-administration