DATA Step, Macro, Functions and more

Calculate AGE using BIRTH and DEATH DATE

Accepted Solution Solved
Reply
Contributor
Posts: 25
Accepted Solution

Calculate AGE using BIRTH and DEATH DATE

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


Accepted Solutions
Solution
4 weeks ago
Super User
Posts: 6,785

Re: Calculate AGE using BIRTH and DEATH DATE

[ Edited ]

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.;

View solution in original post


All Replies
PROC Star
Posts: 1,845

Re: Calculate AGE using BIRTH and DEATH DATE

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'));

 

Contributor
Posts: 25

Re: Calculate AGE using BIRTH and DEATH DATE

Posted in reply to novinosrin
using yrdif and ceil worked..
Thank you,

NASYA
Solution
4 weeks ago
Super User
Posts: 6,785

Re: Calculate AGE using BIRTH and DEATH DATE

[ Edited ]

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.;

Contributor
Posts: 25

Re: Calculate AGE using BIRTH and DEATH DATE

Posted in reply to Astounding
Yes, thats correct
Contributor
Posts: 25

Re: Calculate AGE using BIRTH and DEATH DATE

Posted in reply to Astounding
Worked. Thank you.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 69 views
  • 0 likes
  • 3 in conversation