Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9067 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
/*
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 |
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 |
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 |
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 |
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 |
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 |
Are you involved in writing the inferential analysis plan? Tables specfications?
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
Mention what is SAS data set?
Differentiate input and infile.
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
Describe the ways in which you can create macro variables? : sas-macro
Explain the use of proc print and proc contents?
what is cummaltive frequency,and varience in proc unviarte
Tell different ways to create Macrovarible?
3 Answers Accenture, PharmaNet i3,
Identify statements whose placement in the DATA step is critical?
What is the difference between SAS functions and procedures?
is there any difference between proc summary and proc means?
Teradata 
