topic Re: Converting age from days to years in SAS Programming

Converting age from days to years

Rou — Tue, 01 Nov 2022 04:19:36 GMT

Hi all,

The age variable in my dataset is reported in days, how do I can convert that to age in years?

Thanks

Re: Converting age from days to years

Kurt_Bremser — Tue, 01 Nov 2022 07:58:20 GMT

The best way to calculate the age is by using the YRDIF Function with the date of birth and TODAY() as arguments.

From a number of days, use FLOOR(days / 365.25).

Edit: added links to the function documentation.

Re: Converting age from days to years

Rou — Wed, 02 Nov 2022 00:58:33 GMT

Thank you!

Re: Converting age from days to years

Hdababs — Wed, 22 Mar 2023 22:54:36 GMT

Greetings,

How do I calculate age while using a connection to teradata date of birth field.

This is what I tried so far:

PROC SQL;

...

select
DMA.MCID
,frfm.HCC_CD
,DMA.GNDR_NM
,floor ((intck('month',DMA.MBR_BRTH_DT,today()) - (day(today()) < day(DMA.MBR_BRTH_DT))) / 12) as age
,INCRD_YEAR_MNTH_NBR
,case when max(PRORTD_MBR_MNTH_CNT) >0 then 1 else 0 END AS PRORTD_MBR_MNTH_CNT

ERROR: Teradata prepare: Syntax error: expected something between '(' and the string 'month'.

Re: Converting age from days to years

Kurt_Bremser — Thu, 23 Mar 2023 06:37:04 GMT

If this is part of an explicit pass-through (we can't tell, as you did not post the complete code), you must use Teradata syntax.

Re: Converting age from days to years

Hdababs — Thu, 23 Mar 2023 13:08:19 GMT

Thank you. I used teradata syntax.

Here is what I used:

('2022' - extract(year from teradata birth date column name)) as Age

Re: Converting age from days to years

Kurt_Bremser — Thu, 23 Mar 2023 13:10:32 GMT

See my answer to your other post concerning the same issue.