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?

Answers were Sorted based on User's Feedback



In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject t..

Answer / bakul shah

/*
Bakul Shah
6/May/2009
*/
Data A ;
Array N{6};
Input Name $ N{*} ;
Call SortN(of N{*}); /* Sort for Intergers */
Put @5 Name $ @10 N{6} 3. +2 N{5} 3.;/* 6th and 5th */
DataLines;
David 76 81 65 87 78 98
Manisha 100 91 67 86 87 81
Bob 83 93 76 88 96 72
;
Run;
*;

Is This Answer Correct ?    6 Yes 0 No

In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject t..

Answer / 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

In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject t..

Answer / ashokmudrathi

data rating;
input a b c d e f;
cards;
1 54 21 5 7 2
2 21 54 67 3 5
;
*here 1000 observations with above variables;

data nrate;
set rating;
array r{6} a -- f;
do i=1 to 6;
*for first maximum;
if r{i}>max1 then max1=r{i};
*for second maximum;
if r{i}>max2 and r{i}<max1 then max2=r{i};
end;

proc print;
run;

Is This Answer Correct ?    4 Yes 3 No

In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject t..

Answer / 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

In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject t..

Answer / basha

just i imagine data in data base is;
like below output dataset:
data rating;
input name $ a b c d e f;
cards;
raj 1 54 21 5 7 2
jar 2 21 54 67 3 5
;
answer:

proc sort data=rating;
by name;
run;
proc transpose data=rating out=marks(rename=(col1=marks
_name_=subjects) drop=_label_);
by name;
run;
proc sort data=marks;
by descending marks name;
run;
data jj;
set marks;
by name;
if first.name then ind=0;
ind+1;
run;
proc print;
where ind in(1,2);
run;

Is This Answer Correct ?    2 Yes 3 No

In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject t..

Answer / hahaha

proc sort data=marks;
by name descending marks ;/*for answer 2, just change the
order*/

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SAS Interview Questions

what is washout period?

3 Answers   Cognizant,


Difference Between Scan and Substr

2 Answers  


what is Enterprise Guide?what is the use of it?

2 Answers   CitiGroup, Oracle,


i have one dataset data l; input name: $ 25; cards; manoj is a good boy to krishna krishna is a god boy to malli malli is good boy to ramana ques: here i want "manoj" observations nubers

3 Answers   SAS,


what is syntax of proc merge ?

7 Answers   TCS,






What is maximum number of rows and cols can be handled in SAS?

0 Answers   Signetsoft,


what are several options for creating reports in web report studio? : Sas-bi

0 Answers  


Intern stastical programmer written test

0 Answers  


Mention common programming errors committed in sas ?

0 Answers  


The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend?

6 Answers   Oracle,


what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

0 Answers  


how many types of MERGE?

17 Answers   CitiGroup,


Categories