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;

if reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record

4 Answers   HSBC,

---

Enlist the functions performed by sas.

0 Answers  

---

How many ways to overcome a missing values???

0 Answers   HSBC,

---

diff between nodup rec and ondup key???

3 Answers   AON, Sciformix,

---

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

0 Answers  

---

Are you familiar with special input delimiters? How are they used?

4 Answers   Accenture,

---

There is a river notoriously known for it?s large crocodile population. With ease, how do you safely cross it?

1 Answers   Oracle,

---

wat has been most common programming mistake?

3 Answers  

---

I need level 2 to 5 sas using companies in india

0 Answers  

---

How is character variable converted into numeric variable and vice versa?

0 Answers  

---

how can you sort the dataset having millions of OBS(instead of sort procedure?

4 Answers   EXL,

---

Have you ever used the SAS Debugger?

0 Answers   Quintiles,

---