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
explain about various caches available in data integrator? : Sas-di
describe the interaction table in sas di? : Sas-di
what are some good sas programming practices for processing very large data sets? : Sas programming
How are numeric and character missing values represented internally?
Where do you use proc means over proc freq?
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
Which date function advances a date, time or datetime value by a given interval?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
What are the different operating system platforms in which we can use sas? : sas-grid-administration
what other sas products have you used and consider yourself proficient in using? : Sas programming
What is the basic structure of a sas program?
What are the parameters of scan function?
What is a method to debug and test your SAS program?
what r the job openings SAS for fresher graduates !
What is the maximum length of the macro variable? : sas-macro