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;

Differentiate between sas functions and sas procedures.

0 Answers  

---

how many data types in sas? : Sas-administrator

1 Answers  

---

what are the new features included in the new version of SAS i.e., SAS9.1.3?

5 Answers   College School Exams Tests, Wockhardt,

---

How many tiers in sas architecture?

2 Answers  

---

is it possible to generate sas datasets using proc print ???

1 Answers   GSK GlaxoSmithKline,

---

Tell me about % include and % eval? : sas-macro

0 Answers  

---

Explain the difference between informat and format with an example.

0 Answers  

---

Difference Between Scan and Substr

2 Answers  

---

Which is Best Institute for learning SAS BASE & SAS BI in Hyderabad? Can anyone suggest me ?

5 Answers   ACC,

---

How do you add a number to a macro variable? : sas-macro

0 Answers  

---

i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one.

6 Answers   CTS,

---

how do u validate sas program

3 Answers   Accenture,

---