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;

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

0 Answers   Accenture, Quintiles,

---

What would the following datastep do? Data _null_; Set Dist end=eof; Call Symput("xx"!!left(put(_n_,2.)),&dimension); If EOF then Call Symput('numrows',left(put(_n_,2.))); Run; dimension is a macro variable that is being passed here

2 Answers  

---

Do you need to rearrange the order of the data for the report?

0 Answers  

---

What is the purpose of _character_ and _numeric_?

0 Answers  

---

Hot to suppress characters from a given string?

4 Answers   CTS,

---

what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

0 Answers  

---

6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK

1 Answers   IBM, SAS,

---

How many ways to overcome a missing values???

0 Answers   HSBC,

---

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

0 Answers  

---

How would you code the criteria to restrict the output to be produced?

9 Answers  

---

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

0 Answers   HSBC,

---

how can u convert this 25-jul-2010 from numeric to charcter?

3 Answers  

---