topic Re: Calculate current age in SAS Programming

Calculate current age

Kalai2008 — Wed, 12 Jul 2017 15:24:36 GMT

Hello All,

Thanks for Checking!

I am trying to calculate the age for each person , but I am getting the same age 52 for all the accounts. Please help

proc sql;
create table test.age
as select acct,
int(yrdif(s.Birth_year1,today())) as Age
from test.data s;
run;

Output:

acct age
123 52
124 52
362 52

Re: Calculate current age

PaigeMiller — Wed, 12 Jul 2017 15:25:41 GMT

I think you have to show us (a portion of) the input data for us to be able to help you.

Re: Calculate current age

Reeza — Wed, 12 Jul 2017 15:27:54 GMT

Is s.birth_year1 a year or a SAS date. If it's a year this wouldn't work because YRDIF expects Dates.

Re: Calculate current age

Kalai2008 — Wed, 12 Jul 2017 15:30:36 GMT

Input Data :

Acct birth_year1

201003 1952

12365 1968

23568 1965

Thank you!

Re: Calculate current age

Kalai2008 — Wed, 12 Jul 2017 15:32:33 GMT

Right ! Birth_year1 -- Its NUM and in BEST12. format.

Re: Calculate current age

Reeza — Wed, 12 Jul 2017 15:33:28 GMT

So, how does one calculate an age from a date and year? What are you expecting as the answer?

FYI - this is a logic issue/problem definition not an actual programming problem.

Re: Calculate current age

Kalai2008 — Wed, 12 Jul 2017 15:35:46 GMT

I need to calculate the age of that person. I already have his birthyear and need to calculate the person's age in separate column.

Re: Calculate current age

Astounding — Wed, 12 Jul 2017 15:42:09 GMT

If that's all the information you have, why not use a simple formula:

2017 - birth_year1 as age,

Re: Calculate current age

Reeza — Wed, 12 Jul 2017 15:44:10 GMT

Whats the formula though? Age is usually calculated based on dates but you don't have dates so you can't calculate an exact age. So how do you want to calculate age?

Is it use a mid year value? Or just pick highest age? Or stand on one foot and throw a dart? I can show you code for all...including the last option.

Re: Calculate current age

Kalai2008 — Wed, 12 Jul 2017 20:09:23 GMT

Thank you..It worked