Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

What is SAS? What are the functions does it performs?

1165


which date functions advances a date time or date/time value by a given interval? : Sas programming

926


what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

990


how many types of prompts are there? : Sas-bi

1059


What is the sas data set? : sas-grid-administration

947


What are the difference between sas functions and procedures?

1100


Describe the ways in which you can create macro variables? : sas-macro

1038


what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1100


i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

2351


Mention what is the difference between nodupkey and nodup options?

988


Enlist the syntax rules followed in sas statements.

1056


why is sas data integration studio important? : Sas-di

1010


What does P-value signify about the statistical data?

1332


What are the uses of sas?

1209


Describe the function and untility of the most difficult SAS macro that you have written.

2077