Calculate AGE using BIRTH and DEATH DATE

[Nasya]

Hi,

When trying to calculate the age using death and birth dates, leaves output as 50.7677488 etc. However, displaying  values like this 51 is expected instead of 50.7677488.

data data1_;
	attrib BRTHDAT_ DTHDAT_  length=8 format=date9.;
	attrib AGE_D length=3;
	set data1;

if BRTHDAT ne . then
	BRTHDAT_=datepart(BRTHDAT);

if DTHDAT ne . then
	DTHDAT_=datepart(DTHDAT);

if DTHDAT_ ne . and BRTHDAT_ ne . then do;
	AGE_D=(DTHDAT_ - BRTHDAT_)/365.25;
end;

proc sort data=data1_;
	by SUBJECT;
run;

Attached is the code.

Any correction that has to be made to display the age right?

Thank you,

Regards,

Nasya

[novinosrin]

can ceil function help?

if DTHDAT_ ne . and BRTHDAT_ ne . then do;
	AGE_D=ceil((DTHDAT_ - BRTHDAT_)/365.25);

or using yrdif and ceil

   age=ceil(yrdif(brthdat_, dthdat_, 'AGE'));

[Nasya]

using yrdif and ceil worked..
Thank you,

NASYA

[Astounding · Accepted solution]

I imagine you are looking for the age to be rounded:

if DTHDAT_ ne . and BRTHDAT_ ne . then do;
AGE_D= round((DTHDAT_ - BRTHDAT_)/365.25);
end;

Alternatively, leave the calculations as they are, but change the attributes of AGE_D:

attrib AGE_D length=8 format=3.;

[Nasya]

Yes, thats correct

[Nasya]

Worked. Thank you.