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
- 2544 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 are all the problems you faced while validating tables and reports?
What is substr function?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
How are numeric and character missing values represented internally?
what is the difference between infile and input? : Sas-administrator
Why double trailing @@ is used in input statement?
If a variable contains only numbers, can it be a character data type?
How do dates work in sas?
Given an unsorted data set, how to read the last observation to a new data set?
how many types of prompts are there? : Sas-bi
What is factor analysis?
What is the sas data set? : sas-grid-administration
Describe the ways in which you can create macro variables?
Are you sensitive to code walk-throughs peer review or QC review?
