Computing age in SAS 9.3

It seems like such a simple problem: how can you reliably compute the age of someone or something? Susan lamented the subtle issues using the YRDIF function exactly 1.0356164384 years ago.

Sure, you could write your own function for calculating such things, as I suggested 0.1753424658 years ago.

Or you could ask your colleagues in the discussion forums, as I noticed some people doing just about 3.7890410959 years ago.

Or, now that SAS 9.3 is available, you can take advantage of the new AGE basis that the YRDIF function supports. For example:

data _null_;
  x = yrdif('29JUN2010'd,today(),'AGE');
  y = yrdif('09MAY2011'd,today(),'AGE');
  z = yrdif('27SEP2007'd,today(),'AGE');
  put x= y= z=;


x=1.0356164384 y=0.1753424658 z=3.7890410959

This new feature and many more were added in direct response to customer feedback from Susan and others. And that's a practice that never gets old.
tags: sas 9.3, SAS programming, SAS support, SAS tips


  1. Susan Slaughter
    Posted July 12, 2011 at 11:30 am | Permalink

    Wow, I am so excited that there is finally a definitive way to compute ages!!!

    Thanks for giving me credit, although I notice that they didn't use my suggestion that there should be an easy version of this function

    x = AGE(birthdate);

    The YRDIF solution is great for programmers, but it's going to confuse non-programmers. Maybe they'll put that in SAS 9.4?

  2. Chris
    Posted July 12, 2011 at 11:37 am | Permalink


    With FCMP, you can package up your own AGE function:

    proc fcmp outlib=work.myfuncs.dates;
    function age(d);
    run; quit;

    /** to use it **/
    options cmplib=work.myfuncs;
    data _null_;
    x = age('29SEP2007'd);
    put x=;

  3. Doc Muhlbaier
    Posted July 17, 2011 at 10:47 pm | Permalink


    The YRDIF documentation is a bit sketchy. Does it precisely calculate the integer years of age (like Billy Kreuter's macro did)? I.e. will

    FLOOR(YRDIF(begin, end, 'AGE'));

    *always* provide the person's age in years. I'm concerned with roundoff (for things like determining Medicare eligibility).


  4. Prashant Chegoor
    Posted November 2, 2011 at 1:10 pm | Permalink

    I think if we assume that people who are born on 29th Feb in a leap Year celebrate their birthdays on 28th Feb in a non leap year and on 29th Feb in a Leap year then the following accurately calculates the Age of a Person in SAS 9.2 for all date ranges :

    Data _NULL_ ;

    BirthDate ='29Feb2008'd;

    Age = intck("year",BirthDate,EndDate)-(put(BirthDate,mmddyy4.) gt put(EndDate,mmddyy4.))+(put(BirthDate,mmddyy4.)="0229" and put(EndDate,mmddyy4.)="0228" and put(EndDate+1,mmddyy4.)="0301");

    Put BirthDate=date9. EndDate=date9. Age=;


    This gives BirthDate=29FEB2008 EndDate=28FEB2009 Age=1 in the SAS Log.

    I wonder if the YRDIF function in SAS 9.3 does the same too.

    • Chris Hemedinger Chris Hemedinger
      Posted November 2, 2011 at 1:12 pm | Permalink

      Prashant - yes, I believe it does work correctly for leap years. I tried your example and it worked simply with:

      Age2 = yrdif(BirthDate,EndDate,'AGE');

      • Prashant Chegoor
        Posted November 2, 2011 at 9:02 pm | Permalink

        Thanks for the Confirmation Chris.

  5. Lex
    Posted March 8, 2012 at 11:18 am | Permalink

    These formulas are not the same though in a leapyear.

    Data _NULL_ ;
    BirthDate ='29Feb2008'd;
    Age = intck("year",BirthDate,EndDate)-(put(BirthDate,mmddyy4.) gt
    put(EndDate,mmddyy4.))+(put(BirthDate,mmddyy4.)="0229" and put(EndDate,mmddyy4.)="0228" and put(EndDate+1,mmddyy4.)="0301");
    Put BirthDate=date9. EndDate=date9. Age= Age2=;

    BirthDate=29FEB2008 EndDate=28FEB2012 Age=3 Age2=4

    • Mike Atkinson
      Posted August 26, 2016 at 7:15 pm | Permalink

      I agree, Lex, in this case (on multiples of 4 years after a Feb 29), YRDIF incorrectly increments the age on the 28th of the month instead of the 29th. No one born February 29th is going to celebrate their fortieth birthday on the 28th when there is a 29th in that year! The following statement, using the new-ish CONTINUOUS method for INTCK, calculates it correctly (as an integer) in all cases:

      age3 = INTCK('YEAR', BirthDate, EndDate, 'C');

      • Chris Hemedinger Chris Hemedinger
        Posted August 29, 2016 at 7:53 am | Permalink

        I have found that when it comes to leap year and how to count age, there is lots of opportunity to poke holes in the various algorithms. I think it comes down to the question you are trying to answer. "What is Joe's exact age in years?" might be different than "What day should I mail Joe's birthday card so it arrives on his birthday?"

One Trackback

  1. By Visualize the ages of US presidents - The DO Loop on November 14, 2016 at 6:29 am

    […] don't have to read the ages into SAS. If you have the president's birth date, SAS can use YRDIF function the compute the president's age at any subsequent […]

Post a Comment

Your email is never published nor shared. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>