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
How do you use the do loop if you don’t know how many times you should execute the do loop?
what is change analysis in sas di ? : Sas-di
describe how to adjust the performance of data integrator? : Sas-di
what is the use of sas management console? : Sas-di
What is SAS?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
AE datasets names? how many types?
What’s the difference between var b1 – b3 and var b1 — b3?
explain the difference between proc means and proc summary?
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
what are the scrubbing procedures in sas? : Sas programming
Explain the purpose of retain statement.
What is the basic structure of the SAS base program?
what type of graphs we will create(for 2+years candidates)?
How would you define the end of a macro? : sas-macro