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
- 1 Answers
- 2266 Views
- Accenture, HSBC, I also Faced
- E-Mail Answers
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
How sas treats the dsd delimiters?
How would you identify a macro variable?
What do you know about sas data set?
Enlist the syntax rules followed in sas statements.
What is the difference between match merge and one to one merge?
how can you put a "trace" in your program? : Sas programming
How to create list output for cross-tabulations in proc freq?
Which date function advances a date, time or datetime value by a given interval?
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
What are the features of base sas system?
Explain how merging helps to combine data sets.
What is PDV?
In SAS explain which statement does not perform automatic conversions in comparisons?
What is the difference between the proc sql and data step?
describe how to adjust the performance of data integrator? : Sas-di
