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.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the automatic variables for macro? : sas-macro

1257


If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1494


What is the maximum length of the macro variable? : sas-macro

1095


What are the special input delimiters used in SAS?

1184


List out some key concept of SAS

1131


What is the use of stop statement?

1086


What is the difference between using drop = data set option in data statement and set statement?

1166


What is PROC in SAS?

1058


how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2761


What is SAS informats?

1109


what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

1011


How do you connect the desktop application to metadata server? : sas-grid-administration

1101


What is the difference between SAS functions and procedures?

1153


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

2570


How does the internal authentication work in sas? : sas-grid-administration

1123