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
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.
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.
Thank you, it worked!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.