How to get top scorer student from a class-table having
different sections A,B, C & D? Each section having same
number of students.

Answers were Sorted based on User's Feedback



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

Answer / shambhu kumar verma

Proc Sort data = AAA;
by section descending score;
run;

Data BBB;
set AAA;
by section;
if first.section;
run;

Is This Answer Correct ?    5 Yes 0 No

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

Answer / aloor

proq sql;
Select * from class where score =(select max(score) from
class);
quit;

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SAS Interview Questions

what is sas metadata server? : Sas-di

0 Answers  


what are sas bi dashboard components? : Sas-bi

0 Answers  


What are the parameters of scan function?

0 Answers  


What will calendar procedure do?

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  






How do you put a giraffe into the refrigerator?

3 Answers   Oracle,


I have a dataset concat having a variable a b & c. How to rename a b to e & f?

0 Answers  


How would you code the criteria to restrict the output to be produced?

9 Answers  


Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT SAS Training in Data Management at InfoSchool Bangalore

1 Answers  


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

0 Answers  


what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

0 Answers  


when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.

1 Answers  


Categories