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 / santosh reddy

data x;
set rating;
max1=max(of a--f);
array aa(6) a--f;
do i=1 to 6;
if aa(i)>max2 and aa(i)<max1 then max2=aa(i);
end;
run;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give e an example of..

1638


What is the command used to find missing values?

580


what is snowflake schema? : Sas-di

682


In SAS explain which statement does not perform automatic conversions in comparisons?

788


In sas admin differentiate between roles and capabilities? : sas-grid-administration

548






Differentiate between proc means and proc summary.

591


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3099


What is by-group processing?

567


what is data access? : Sas-di

591


what is the use of proc sql? : Sas programming

580


name the scheduler for scheduling job and explain the scheduler? : Sas-di

577


Intern stastical programmer written test

274


how could you generate test data with no input data? : Sas programming

609


Explain bmdp procedure?

600


What is the good sas programming practices for processing large data sets?

619