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
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 |
Answer / aloor
proq sql;
Select * from class where score =(select max(score) from
class);
quit;
| Is This Answer Correct ? | 1 Yes | 0 No |
how to generate the test data in sas without input data? : Sas-administrator
We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B
what are different type of sas servers ? On which server does the sas code execute ?
How would you define the end of a macro? : sas-macro
What’s the difference between var b1 – b3 and var b1 — b3?
What is difference between N and n????
What are the five ways to do a table lookup in sas? : sas-grid-administration
what is SAS OPTIMIZATION?
Explain the difference between using drop = data set option in set and data statement?
how do u identify a macro variable
what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?
What do the SAS log messages "numeric values have been converted to character" mean?