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
- 2918 Views
- Accenture, HSBC, I also Faced
- E-Mail Answers
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 |
How do you put a giraffe into the refrigerator?
wt is a-z and a--z?
What are the features of base sas system?
how to delete the duplicates by using proc sql?
What is run-group processing?
what are scrubing procedures in SAS?
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
What do you code to create a macro? : sas-macro
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
What commands are used in the case of including or excluding any specific variables in the data set?
What is the role of unrestrictive users? : sas-grid-administration
How will you generate test data with no input data?
Teradata 
