Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

Answers were Sorted based on User's Feedback



How to get second top scorer student from a class- table having different sections A, B, C & D?..

Answer / maddy

proc sql;
select max(score) < (select max(score) from table)

from table;
quit;

Is This Answer Correct ?    3 Yes 0 No

How to get second top scorer student from a class- table having different sections A, B, C & D?..

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

How to get second top scorer student from a class- table having different sections A, B, C & D?..

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

How to get second top scorer student from a class- table having different sections A, B, C & D?..

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

Post New Answer

More SAS Interview Questions

Baseline definition in your study

3 Answers   Accenture, Quintiles,


What is the purpose of using the N=PS option?

2 Answers   Oracle,


what versions of sas have you used (on which platforms)? : Sas programming

0 Answers  


Describe the function and utility of the most difficult SAS macro that you have written?

0 Answers   Oracle,


What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

0 Answers  


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?

7 Answers  


What is the difference between %local and %global?

1 Answers  


In sas admin differentiate between roles and capabilities? : sas-grid-administration

0 Answers  


how do we mail reports from SAS environment to our team leader

5 Answers   Wockhardt,


What is the maximum length of the macro variable?

0 Answers  


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.

9 Answers   Quintiles,


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

0 Answers  


Categories