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 |
what is the main difference between rename and label? (don't say that they both perform the same function).
What procedure you used to calculate p-value?
2 Answers Accenture, Quintiles,
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
what is data access? : Sas-di
i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?
What are the criticality that you have faced during your project in SAS?
Where do the database management systems store data and how do u import them.
create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
what are some good sas programming practices for processing very large data sets? : Sas programming
What are the functions which are used for character handling functions?
What does the trace option do?