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
What are the automatic variables for macro? : sas-macro
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
What is the maximum length of the macro variable? : sas-macro
What are the special input delimiters used in SAS?
List out some key concept of SAS
What is the use of stop statement?
What is the difference between using drop = data set option in data statement and set statement?
What is PROC in SAS?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
What is SAS informats?
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
How do you connect the desktop application to metadata server? : sas-grid-administration
What is the difference between SAS functions and procedures?
Describe the function and utility of the most difficult SAS macro that you have written?
How does the internal authentication work in sas? : sas-grid-administration