/* 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,

---

What are the features of SAS?

0 Answers  

---

how can u join the two tables without using proc sql Joins and nested queries ?

6 Answers   IBM,

---

how to display duplicated observations in a data using base sas.

13 Answers   HCL, TCS,

---

What SAS statements would you code to read an external raw data file to a DATA step?

10 Answers   NIIT,

---

what are 5 ways to perform a table lookup in sas? : Sas-administrator

0 Answers  

---

What is the purpose of the trailing @? The @@? How would you use them?

10 Answers   Accenture,

---

How would you code a merge that will keep only the observations that have matches from both sets?

5 Answers  

---

How would you create multiple observations from a single observation?

1 Answers   Quintiles,

---

Explain the purpose of retain statement.

0 Answers  

---

what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

0 Answers  

---

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

0 Answers  

---