/* 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 can you put a "trace" in your program?

2 Answers   Quintiles,

---

how to write code for left outer join in SAs using datastep?

8 Answers   CitiGroup,

---

Have you been involved in editing the data or writing data queries?

1 Answers   BioServe, Oracle, Sasken,

---

What commands are used in the case of including or excluding any specific variables in the data set?

0 Answers  

---

Name types of category in which SAS Informats are placed?

0 Answers  

---

for whom is sas data integration studio designed? : Sas-di

0 Answers  

---

What is a pdv and what are its functions?

0 Answers  

---

Describe the ways in which you can create macro variables? : sas-macro

0 Answers  

---

What’s the difference between var b1 – b3 and var b1 — b3?

0 Answers  

---

how will you locate the sas platform applications? : Sas-bi

0 Answers  

---

What would be the value of month at the end of data step execution and how many observations would be there?

0 Answers  

---