how to delete the duplicates by using proc sql?

3 Answers   Genpact,

---

How would you delete observations with duplicate keys?

6 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,

---

how to read character value without using substr function in sas ?

3 Answers  

---

What is the difference between %local and %global? : sas-macro

0 Answers  

---

What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

0 Answers  

---

Code a PROC MEANS that shows both summed and averaged output of the data.

5 Answers  

---

What is the order of evaluation of the comparison operators: + - * /** ()?

3 Answers   Quintiles,

---

how to import HTML files into SAS datasets?

3 Answers   HP,

---

What are the joins,types of joins and thier functions?

7 Answers   SAS,

---

What is the general format of function in sas? : sas-grid-administration

0 Answers  

---

what does .. meant in sas macros

3 Answers   D&B,

---