Answer / gaurav gupta

SELECT DISTINCT statement in PROC SQL

Answer / xxx

proc sql;
select id where id(select id from tablename)group by id
having id>1;
quit;

What are the table names in oracle database...?

0 Answers   HSBC,

---

What is the use of function Proc summary?

0 Answers  

---

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 proc means and proc tabulate?

3 Answers   Cognizant, CTS,

---

where will go the observations that were deleted by delete statement?

2 Answers  

---

---

Is it possible to do sorting tranformation in charecter variable??if can tell me one eg..

1 Answers  

---

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

3 Answers   HSBC,

---

How are the analysis data sets structured?

3 Answers  

---

Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

0 Answers  

---

Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?

2 Answers  

---

how do you debug and test your sas programs? : Sas programming

0 Answers  

---

In proc transpose and data step with arrays which one you pick?

0 Answers   Accenture, Quintiles,

---