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
Describe the function and untility of the most difficult SAS macro that you have written.
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
How do you connect the desktop application to metadata server? : sas-grid-administration
what do the pad and dim functions do? : Sas programming
why is sas data integration studio important? : Sas-di
Explain what is the use of proc gplot?
Explain what Proc glm does?
How to limit decimal places for variable using proc means?
What do you understand by the term Normal Distribution?
what are the benefits of data integration? : Sas-di
what is data integration? : Sas-di
what is sas business intelligence? : Sas-bi
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
Have you used macros? For what purpose you have used? : sas-macro