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



Below is the table. Required to be output should be the highest number of each st..

Answer / 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

More SAS Interview Questions

When merging 2 datasets with a common variable (not merge key), how to keep both?

3 Answers  


What is factor analysis?

0 Answers  


Do you think professionally?

1 Answers   Oracle,


Name types of category in which SAS Informats are placed?

0 Answers  


Mention how to limit decimal places for the variable using proc means?

0 Answers  






Where do you use proc means over proc freq?

0 Answers  


What is the purpose of _character_ and _numeric_?

0 Answers  


Identify statements whose placement in the DATA step is critical.

6 Answers   Accenture, Labasol,


What are the differences between proc means and proc summary?

0 Answers  


my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?

2 Answers   Dr Reddys, Oracle,


how to generate report for 0 observation dataset?

3 Answers   Mind Tree, Student,


how do the in= variables improve the capability of a merge? : Sas programming

0 Answers  


Categories