Answer / shambhu kumar verma

Proc Sort data = AAA;
by section descending score;
run;

Data BBB;
set AAA;
by section;
if first.section;
run;

Answer / aloor

proq sql;
Select * from class where score =(select max(score) from
class);
quit;

how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 -2 -3 ; run; adding all +ve value in one varibale n do the same for -ve too

5 Answers   CTS,

---

what is the difference between x=substr(name,1,2); and substr(name,1,2)='x';

3 Answers   HSBC,

---

WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

0 Answers   Satyam,

---

how can u join the two tables without using proc sql Joins and nested queries ?

6 Answers   IBM,

---

What is Transaction...? And what are Comment, Roll back n Save point..?

2 Answers  

---

How would you code a merge that will keep only the observations that have matches from both sets.

5 Answers   Accenture, Bank Of America,

---

explain what is data set in sas? : Sas-administrator

0 Answers  

---

How do you define proc in sas? : sas-grid-administration

0 Answers  

---

Name and describe three SAS functions that you have used, if any?

4 Answers   Accenture,

---

is there any difference between proc summary and proc means?

3 Answers  

---

What are the ways to do a “table lookup” in sas?

0 Answers  

---

diff between nodup rec and ondup key???

3 Answers   AON, Sciformix,

---