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 / ashutosh
slightly modified
data nrate;
set rating;
array r{6} a -- f;
do i=1 to 6;
*for first maximum;
if r{i}>max1 then
do
max2=max1;
max1=r{i};
end;
*for second maximum;
if r{i}>max2 and r{i}<max1 then max2=r{i};
end;
proc print data=nrate;
run;
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is null hypothesis? why do you consider that?
What was the last computer book you purchased? Why?
What is the order of application for output data set options, input data set options and SAS statements?
which features do you use to check the data validations and errors? : Sas-administrator
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
Do you know the features of sas?
Do you need to know if there are any missing values?
Explain bmdp procedure?
Describe a time when you were really stuck on a problem and how you solved it?
Explain by-group processing?
where are dashboard components are created and maintained? : Sas-bi
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
what versions of sas have you used (on which platforms)? : Sas programming
what is sas enterprise intelligence architecture? : Sas-bi
Explain the difference between nodup and nodupkey options?