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

Describe a time when you were really stuck on a problem and how you solved it?

2083


Mention the difference between ceil and floor functions in sas?

647


What is the order of application for output data set options, input data set options and SAS statements?

1080


what is business intelligence? : Sas-bi

583


what is the difference between infile and input? : Sas-administrator

607






Explain how merging helps to combine data sets.

616


What will calendar procedure do?

593


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

762


What is the purpose of trailing @ and @@? How do you use them?

611


what do the mod and int function do? What do the pad and dim functions do? : Sas programming

613


How long can a macro variable be? A token? : sas-macro

716


how do you want missing values handled? : Sas programming

533


Have you ever used the SAS Debugger?

1207


Mention some common errors that are usually committed in sas programming.

588


What is the difference between %put and symbolgen? : sas-macro

669