topic No.of days between birth date and today's date in SAS Programming

No.of days between birth date and today's date

sambasiva_ravuri_tcs_com — Thu, 15 Mar 2012 10:39:46 GMT

Dear All,

Am having the date of Births as Input and i would like to write using DATE Functions, the no.of days between Birth Date and Today's Date in output dataset ?

11/12/87

12/04/56

03/06/79

04/05/94

03/07/99

Kindly help me.

Regards,

S Ravuri.

No.of days between birth date and today's date

Haikuo — Thu, 15 Mar 2012 11:11:08 GMT

Officially, Intck().But in your case, '-' will be sufficient.

data have;

input bday mmddyy8.;

format bday mmddyy8.;

cards;

11/12/87

12/04/56

03/06/79

04/05/94

03/07/99

;

data want;

set have;

ageindays=intck('day',bday,today());

ageindays_=date()-bday;

run;

proc print;run;

I choose to use month/day/year to inteprete your data, although it can be intepreted in other ways as well.

Regards,

Haikuo

No.of days between birth date and today's date

Hima — Thu, 15 Mar 2012 12:32:13 GMT

data have;
input bday mmddyy8.;
format bday mmddyy8.;
cards;
11/12/87
12/04/56
03/06/79
04/05/94
03/07/99
03/07/99
;
run;

data want;
set have;
age_days = today() - bday;
run;

proc print; run;

Output:

Obs bday age_days

                                   1     11/12/87       8890
                                   2     12/04/56      20190
                                   3     03/06/79      12063
                                   4     04/05/94       6554
                                   5     03/07/99       4757
                                   6     03/07/99       4757