topic Re: Deriving AGE from YEAR of BIRTH in Programming 1 and 2

Deriving AGE from YEAR of BIRTH

Zacc — Tue, 05 Apr 2022 18:33:33 GMT

First, I do have a variable, year of birth (i.e. without days and months of births). Second, I would like to derive age from the stated variable based on today’s date. I’ve attempted the derivation using the following code but I’ve been unsuccessful.

Data myage;
set suvdata;
AGE=floor(YRDIF(RB080, today(),"AGE"));
run;

I shall be most grateful for your help.

Re: Deriving AGE from YEAR of BIRTH

ballardw — Tue, 05 Apr 2022 18:59:15 GMT

The YRDIF function want two date values. So use the MDY function to create date

AGE=floor(YRDIF(mdy(1,1,RB080), today(),"AGE"));

would use January 1 as the date in the year.

Re: Deriving AGE from YEAR of BIRTH

PaigeMiller — Tue, 05 Apr 2022 18:43:24 GMT

@Zacc wrote:

First, I do have a variable, year of birth (i.e. without days and months of births).

So in other words, you just have the year of birth, is that what you are saying? The value of your variable might look like 1978.

So you would compute the age via

data want;
set have;
age = 2022 - rb080;
run;

Re: Deriving AGE from YEAR of BIRTH

Zacc — Wed, 06 Apr 2022 04:14:44 GMT

@ballardw, Thank you so very much.