Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 8560 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / maddy
proc sql;
select max(score) < (select max(score) from table)
from table;
quit;
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / partha
proc rank data=emp descending ties=dense out=s(where=(inc=1));
by deptno ;
var sal;
ranks inc;
run;
quit;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / wkm
proc sort data=table;
by section descending score;
run;
data table2;
retain tot 0;
set table;
by section descending score;
if first.section then tot=1;
tot+1;
if tot=2;
run;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Why do we use QUIT commmand for proc datasets and proc sql ???
what is _error_?
2 Answers Axis Bank, Cognizant, JPMorgan Chase,
How is character variable converted into numeric variable and vice versa?
What are common programming errors committed in sas
Does anybody has SAS Platform Administration certification dumps. pls send to hariithepalli@gmail.com
What is the general format of function in sas? : sas-grid-administration
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
how to do user inputs and command line arguments in sas?
Explain what is the use of proc gplot?
Describe a time when you were really stuck on a problem and how you solved it?
Which command is used to perform sorting in sas program?
How do you put a giraffe into the refrigerator?
Teradata 
