I want exact age with display like (23 Years,2 weeks,2 day)

[ganeshsas764]

Hi ,

can you please help on  the queary ,

data sample;

datediff=yrdiff('17may1991'd),today(),"ACT/ACT");

run;

I need answer Like this::-"26 years 1 months 10 days"

[Rick_SAS]

You want to use the INTCK and INTNX functions, Read the article and modify the technique in the article 'INTCK and INTNX: Two essential functions for computing intervals between dates in SAS," which gives ages in the form Y YEARS and D DAYS. The article links to the documentation for those functions and a few SAS Global Forum papers that are worth reading.

[art297]

I tested the following on a number of dates and it appears to meet all posibilities:

data sample;
  format date date9.;
  input date date9.;
  years=intck('year',date,today(),'C');
  months=intck('month',date,today(),'C')-(years*12);
  if day(date) le day(today()) then days=day(today())-day(date);
  else days=intck('day',mdy(month(intnx('month',today(),-1,'same')),
                   day(date),
                   year(intnx('month',today(),-1,'same'))),
             today(),'C');
  datediff=catx(' ',years,'years,',months,'months, and',days,'days');
  cards;
17may1991
29jun2016  
28jun2016
27jun2016
26jun2016  
25jun2016  
29may2016  
28may2016
27may2016
26may2016  
25may2016  
;  
run;

Art, CEO, AnalystFinder.com

[Rick_SAS]

Nice. Looks pretty good, Art!

Just to be clear, we are all assuming that the DATE represents some event in the past, which seems to be the case for this question.

[Kurt_Bremser]

Nice work, @art297!

[ganeshsas764]

super ,  Thank you