Below is the table.
Required to be output should be the highest number of each student_id.
Example.
Student_id Subject Marks
1 Hindi 86
2 Hindi 70
3 English 80
.
Calculate sum and average marks for each group of student_id
Example.
Student_id Subject Marks Total Marks Average
1 English 40 181 60.33333
2 English 67 196 65.33333
3 English 80 160 53.33333
PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS
Answer Posted / chaudhary_1989
data a;
input id sub$ marks;
cards;
1 Hindi 86
2 Hindi 70
3 Hindi 80
1 English 80
2 English 34
3 English 39
1 Maths 28
2 Maths 45
3 Maths 12
;
run;
proc sort data = a out=b;
by id descending marks;
run;
data c (drop=total_marks) d;
set b;
by id descending marks;
if first.id then output c;
if first.id then total_marks=marks;
else total_marks+marks;
if last.id then output d;
run;
proc print; run;
proc means data = a mean max sum;
class id;
var marks;
output out=df;
run;
proc means data = a noprint nway;
class id;
var marks;
output out=df sum= mean= max= /autoname;
run;
proc print; run;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is SAS? What are the functions does it performs?
which date functions advances a date time or date/time value by a given interval? : Sas programming
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
how many types of prompts are there? : Sas-bi
What is the sas data set? : sas-grid-administration
What are the difference between sas functions and procedures?
Describe the ways in which you can create macro variables? : sas-macro
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
Mention what is the difference between nodupkey and nodup options?
Enlist the syntax rules followed in sas statements.
why is sas data integration studio important? : Sas-di
What does P-value signify about the statistical data?
What are the uses of sas?
Describe the function and untility of the most difficult SAS macro that you have written.