In a shcool there are 1000 students. After completion of
every test in 6 subjects , each subject teacher submit the
marks of every student at different times and loaded in the
database commonly. How will you seperate the top two
subject marks for each each studet using SAS?
Answer Posted / bakul shah
/*
Bakul Shah
6/May/2009
*/
Data A ;
Array N{6};
Input Name $ N{*} ;
Call SortN(of N{*}); /* Sort for Intergers */
Put @5 Name $ @10 N{6} 3. +2 N{5} 3.;/* 6th and 5th */
DataLines;
David 76 81 65 87 78 98
Manisha 100 91 67 86 87 81
Bob 83 93 76 88 96 72
;
Run;
*;
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Describe a time when you were really stuck on a problem and how you solved it?
Mention the difference between ceil and floor functions in sas?
What is the order of application for output data set options, input data set options and SAS statements?
what is business intelligence? : Sas-bi
what is the difference between infile and input? : Sas-administrator
Explain how merging helps to combine data sets.
What will calendar procedure do?
If a variable contains letters or special characters, can it be numeric data type?
What is the purpose of trailing @ and @@? How do you use them?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
How long can a macro variable be? A token? : sas-macro
how do you want missing values handled? : Sas programming
Have you ever used the SAS Debugger?
Mention some common errors that are usually committed in sas programming.
What is the difference between %put and symbolgen? : sas-macro