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;

wt is a-z and a--z?

3 Answers   Accenture,

---

How would you remove a format that has been permanently associated with a variable? ________________

5 Answers   Quintiles, TCS,

---

What is the difference between an informat and a format. Name three informats or formats.

6 Answers  

---

For what purpose(s) would use the RETURN statement?

1 Answers  

---

what is sas? is a package or tool? give me introduction about sas?

11 Answers   Accenture,

---

how does sas handle missing values in sort order? : Sas programming

0 Answers  

---

Does SAS ‘Translate’ (compile) or does it ‘Interpret’? Explain.

4 Answers   Accenture,

---

i want to upload titles and footnotes to excel file?how it is possible?

1 Answers  

---

What are the features of SAS?

0 Answers  

---

What would you change about your job?

0 Answers   Oracle,

---

Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks

2 Answers  

---

At compile time when a SAS data set is read, what items are created?

5 Answers  

---