DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 42

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

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

03/07/99

Kindly help me.

Regards,

S Ravuri.

Respected Advisor
Posts: 3,156

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

Posted in reply to sambasiva_ravuri_tcs_com

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

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

Regular Contributor
Posts: 233

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

Posted in reply to sambasiva_ravuri_tcs_com

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

Ask a Question
Discussion stats
  • 2 replies
  • 150 views
  • 0 likes
  • 3 in conversation