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
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
how to remove duplicates using proc sql?
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
What would be the value of month at the end of data step execution and how many observations would be there?
What sas features do you use to check errors and data validation?
how sas deals with business intelligence? : Sas-bi
How to create a permanent sas data set?
What do you code to create a macro? : sas-macro
What function CATX syntax does?
Name types of category in which SAS Informats are placed?
What is the difference between INPUT and INFILE ?
What is the use of divide function?
What is a pdv and what are its functions?
How would you invoke a macro? : sas-macro
To what type of programms have you used scratch macros?