Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3023 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
what is sas database server? : Sas-di
What can you learn from the SAS log when debugging?
how will you locate the sas platform applications? : Sas-bi
For what purposes have you used sas macros? : sas-macro
what is the difference between unique key and primary key? : Sas-di
Mention the difference between ceil and floor functions in sas?
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
List out some key concept of SAS
What is the difference between match merge and one to one merge?
What is the difference between the proc sql and data step?
what is snowflake schema? : Sas-di
If money were no object, what would you like to do?
what is sas enterprise intelligence architecture? : Sas-bi
How would you identify a macro variable? : sas-macro
