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.
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 |
Baseline definition in your study
3 Answers Accenture, Quintiles,
What is the purpose of using the N=PS option?
what versions of sas have you used (on which platforms)? : Sas programming
Describe the function and utility of the most difficult SAS macro that you have written?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?
What is the difference between %local and %global?
In sas admin differentiate between roles and capabilities? : sas-grid-administration
how do we mail reports from SAS environment to our team leader
What is the maximum length of the macro variable?
1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming