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
- 8696 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 |
Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS
What is run-group processing?
what is prime numbers? how we can get plc write sas code?
Can Some one Explain How the Datasets from SAS can be loaded in to the MVS OS?
What are the joins,types of joins and thier functions?
How would you define the end of a macro?
What commands are used in the case of including or excluding any specific variables in the data set?
how to import XTP files into SAS datasets?
1 Answers Barclays, Institute For Plasma Research,
how to delete the duplicates by using proc sql?
What are the new features included in the new version of SAS Programming Language?
What is slibref?
Why is a STOP statement needed for the point=option on a SET statement?
Teradata 
