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


Please Help Members By Posting Answers For Below Questions

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

588


Explain the use of proc print and proc contents?

548


what is sas metadata server? : Sas-di

573


What does PROC print, and PROC contents do?

707


What is proc sort?

710






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

743


how to generate the test data in sas without input data? : Sas-administrator

564


How can sas program be validated?

567


If a variable contains letters or special characters, can it be numeric data type?

753


What are pdv and it functions?

587


Enlist the functions performed by sas.

666


What is the difference between order and group variable in proc report?

821


Difference between sum function and using “+” operator?

587


how many display types available in sas bi dashboard? : Sas-bi

622


How do you specify the number of iterations and specific condition within a single do loop?

611