how to delete the duplicate columns permanently in SQL

2 Answers   Satyam,

---

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?

2 Answers  

---

What are the data types that sas contain?

0 Answers  

---

Hi , which book should i refer to for preaparing SAS statistical Exam. Searched a lot on books but still did n't find relevant books

2 Answers  

---

What is criteria for adverse events and treatment-emergent adverse events?

2 Answers   Accenture,

---

---

how to know the attributes of first five datasets in a library

2 Answers  

---

if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??

6 Answers   Accenture,

---

PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?

7 Answers   HP,

---

How will you generate test data with no input data?

0 Answers  

---

What is the difference between nodupkey and nodup options?

0 Answers  

---

/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;

1 Answers   Emerio,

---

Approximately what date is represented by SAS date value of 730

9 Answers  

---