topic Age from BirthDate! in SAS Procedures

Age from BirthDate!

robertrao — Thu, 12 Sep 2013 23:50:54 GMT

Hi,

I have a date(DOB) and I want to know the years?

example:

DOB

12sep1982

I want something like(probably not in decimals)

AGE:

Thanks

Re: Age from BirthDate!

Linlin — Fri, 13 Sep 2013 00:08:17 GMT

data have;

format dob date9.;

input dob date9.;

cards;

02sep1982

;

data want;

set have;

age=int((today()-dob)/365.25);

proc print;run;

Re: Age from BirthDate!

Scott_Mitchell — Fri, 13 Sep 2013 00:59:40 GMT

The INTCK function measures the number of intervals between 2 dates.

DATA WANT;

SET HAVE;

AGE = INTCK('YEAR',DOB,TODAY());

RUN;

Re: Age from BirthDate!

Patrick — Fri, 13 Sep 2013 01:06:08 GMT

age=YRDIF(DoB, today(), 'ACT/ACT') ;

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

Re: Age from BirthDate!

Miracle — Wed, 25 Sep 2019 14:37:47 GMT

Re: Age from BirthDate!

Patrick — Fri, 13 Sep 2013 01:44:55 GMT

Using INTCK() the following would return '1' which I believe is not what you would expect to get as age:

INTCK('YEAR','31DEC2012'd,'01JAN2013'd);

Re: Age from BirthDate!

Scott_Mitchell — Fri, 13 Sep 2013 01:51:45 GMT

Agreed Patrick. Once I read your suggestion regarding YRDIF I remembered that INTCK was the incorrect solution for this scenario.

Re: Age from BirthDate!

Tom — Fri, 13 Sep 2013 01:58:17 GMT

If have SAS 9.3 or higher use YRDIF(dob,eventdt,'AGE');

36977 - Using the YRDIF function to calculate age can give incorrect results in SAS® releases prior to 9.3

Re: Age from BirthDate!

new_sas2015 — Tue, 17 Nov 2015 15:28:22 GMT

I am trying to calculte age as well using SAS 9.4.

this is the code i have used but the age is off by one year. How to correct it?

*creating Mat_age*/;
MAT_AGE = (int(new_DOB - new_MomDOB)/365.25);

Re: Age from BirthDate!

ChrisHemedinger — Tue, 17 Nov 2015 18:39:47 GMT

I think you intended to apply the INT function to the entire computed value, so you need to move a paren:

MAT_AGE = int( (new_DOB - new_MomDOB) /365.25);

But the better way (I think) is to use YRDIF with the AGE modifier:

MAT_AGE = yrdif(new_DOB, new_MomDOB,'AGE');

See: http://blogs.sas.com/content/sasdummy/2011/07/12/computing-age-in-sas-9-3/

Re: Age from BirthDate!

AZIQ1 — Mon, 14 Aug 2017 17:34:02 GMT

Hi,
When I use the INTCK function I get a message (window is full and must be cleared. Select:
F to file.
P to Print
S to save or
C to clear the window without saving

Any insights why this is happening?

Re: Age from BirthDate!

AZIQ1 — Mon, 14 Aug 2017 17:36:07 GMT

Hi,
When I use the INTCK fuction I get a message (window is full and must be cleared. Select:
F to file.
P to Print
S to save or
C to clear the window without saving

Any insights why this is happening?

Re: Age from BirthDate!

NoClassAllSAS — Mon, 13 May 2019 18:51:52 GMT

I believe this happens because the alignment option in the INTCK function defaults to DISCRETE, which counts interval boundaries in between two dates, rather than CONTINUOUS, which counts full intervals in between dates, shifted to the start date.

The following code should work:

AGE = INTCK('YEAR',DOB,TODAY(),'C');

See here for details:

http://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#p1md4mx2crzfaqn14va8kt7qvfhr.htm#n1gtwtxg68khzjn1rkmjlksobk51