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
- 8711 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 |
How the date 04oct1994 is stored in SAS,not only give the answer explain in brief?
How to include or exclude specific variables in a data set?
Explain how you can debug and test your SAS program?
What does the RUN statement do?
What is _n_?
Name statements that function at both compile and execution time?
what is the effect of the options statement errors=1? : Sas programming
What is program data vector (pdv)?
What are the analysis datasets created, and what are the new variables created in CLINICAL SAS
1 Answers Accenture, Sciformix,
What is the difference between a PROC step and a DATA step?
What are the uses of sas?
What are the ways in which macro variables can be created in sas programming?
Teradata 
