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
- 8698 Views
- TCS, I also Faced
- E-Mail Answers
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
How can I remove header from output data set?
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
what is sas business intelligence? : Sas-bi
explain the main difference between the nodup and nodupkey options? : Sas-administrator
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
for whom is sas data integration studio designed? : Sas-di
what is hash files in sas and why we are using this one in sas?
What is the difference between the proc sql and data step?
What are the differences between sum function and using “+” operator?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
Describe the ways in which you can create macro variables? : sas-macro
Of all your work, where have you been the most successful?
What is the difference between match merge and one to one merge?
What are the difference between sas functions and procedures?
How would you include common or reuse to be processed along with your statements?
