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;

Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?

2 Answers  

---

I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?

1 Answers  

---

What do you feel about hardcoding?

3 Answers   Pfizer,

---

what do the pad and dim functions do? : Sas programming

0 Answers  

---

For clinical entire study how many tables will create approx?

0 Answers   TCS,

---

---

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

0 Answers  

---

what kind of variables are collected in AE dataset?

3 Answers   Accenture, Quintiles, SAS,

---

How would you delete observations with duplicate keys?

6 Answers  

---

There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT

8 Answers   D&B,

---

What will calendar procedure do?

0 Answers  

---

Describe the function and utility of the most difficult SAS macro that you have written?

0 Answers   Oracle,

---

Difference Between Scan and Substr

2 Answers  

---