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
- 8829 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 |
Explain proc sort?
what is intially documentation in sas?
Tell me more about the parameters in macro? : sas-macro
Diff between proc sql merge and join?
What are the difference between ceil and floor functions in sas?
Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?
wat is sas? is a package or programming language?
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)
what versions of sas have you used (on which platforms)? : Sas programming
how do i get last 10obs from a dataset when we don't know about the number of obsevations in that dataset?
how would you determine the number of missing or nonmissing values in computations? : Sas programming
Teradata 
