topic Calculate Age from Transaction Date in SAS Enterprise Guide

Calculate Age from Transaction Date

sdang — Mon, 30 Mar 2015 20:29:18 GMT

I looked through all the treads about calculating age and found this line of code:

int(YRDIF(t1.DOB, t1.PlayerDayDate, 'Year'))

The line of code is valid but the column ,AGE, shows missing value or no values. What did I do wrong?

My DOB and PlayerDayDate format are as follow:

22MAR2014:00:00:00

ballardw — Mon, 30 Mar 2015 20:50:07 GMT

The variables have to be DATE valued functions, not DATETIME. Use datepart(t1.dob) and datepart(t1.PlayerDayDate).

I think you want "AGE" as the basis or blank, 'YEAR' should have gotten a warning or error message.

sdang — Mon, 30 Mar 2015 20:56:53 GMT

Thank you, it worked!