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
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
Explain the use of proc print and proc contents?
what is sas metadata server? : Sas-di
What does PROC print, and PROC contents do?
What is proc sort?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
how to generate the test data in sas without input data? : Sas-administrator
How can sas program be validated?
If a variable contains letters or special characters, can it be numeric data type?
What are pdv and it functions?
Enlist the functions performed by sas.
What is the difference between order and group variable in proc report?
Difference between sum function and using “+” operator?
how many display types available in sas bi dashboard? : Sas-bi
How do you specify the number of iterations and specific condition within a single do loop?