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

---

Can you explain the process of calendar?

0 Answers  

---

how to extract data from SAP servers? Is like oracle servers or any other methods to extract please reply me.

1 Answers  

---

Is it possible to do sorting tranformation in charecter variable??if can tell me one eg..

1 Answers  

---

What do you know about sas data set?

0 Answers  

---

how are numeric and character missing values represented internally? : Sas programming

0 Answers  

---

Can you excute a macro within a macro? Describe.

2 Answers   Genta,

---

Suppose there is a SAS dataset with following values - Parent Child A B B C D E F G G H H I and so on….. This goes onto 1000s of observations/rows. Now how do we identify from this dataset Grandparents and Grandchildrens ?

5 Answers   American Express, Barclays,

---

Difference between informat and format?

0 Answers  

---

where to use sas business intelligence? : Sas-bi

0 Answers  

---

Explain data_null_?

0 Answers  

---

what is the purpose of _error_? : Sas programming

0 Answers  

---