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


Please Help Members By Posting Answers For Below Questions

What is the role of sas grid administrator? : sas-grid-administration

931


Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2014


How do dates work in SAS data?

780


how could you generate test data with no input data? : Sas programming

737


what is the difference between nodup and nodupkey options? : Sas programming

735






what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

758


what is data governance? : Sas-di

703


Mention how to limit decimal places for the variable using proc means?

737


Difference between SAS STATA & SPSS?

781


Describe the function and utility of the most difficult SAS macro that you have written?

2121


what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

647


If a variable contains letters or special characters, can it be numeric data type?

879


What are the scrubbing procedures in sas?

665


Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

1898


What do you know about sas and what we do? : sas-grid-administration

689