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?
- 6 Answers
- 7269 Views
- I also Faced
- E-Mail Answers
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 are the scrubbing procedures in sas?
Which statement does not perform automatic conversions in comparisons?
How to sort in descending order?
What are the different servers in sas? : sas-grid-administration
what is the Population you used in your project, is it ITT or PP?
What are the default statistics that proc means produce?
How to specify variables to be processed by the freq procedure?
what is sas data set?
List down the reasons for choosing sas over other data analytics tools.
Give an example where SAS fails to convert character value to numeric value automatically?
What is the difference between match merge and one to one merge?
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
I need level 2 to 5 sas using companies in india
explain the function of substr in sas? : Sas-administrator
