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 do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
why is sas data integration studio important? : Sas-di
What are the special input delimiters used in SAS?
Which function is used to count the number of intervals between two sas dates?
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
How to limit decimal places for variable using proc means?
What is the maximum and minimum length of macro variable
Hi, If anyone has base SAS certification dumps, please share.
What is the difference between order and group variable in proc report?
What is your favorite all time computer book? Why?
What are the prime responsibilities of data integration administrator? : Sas-di
What are the automatic variables for macro? : sas-macro
What is by-group processing?
What is proc sort?
Mention some common errors that are usually committed in sas programming.