topic Re: I want exact age with display like (23 Years,2 weeks,2 day) in SAS Programming

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

ganeshsas764 — Tue, 27 Jun 2017 17:44:33 GMT

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"

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

Rick_SAS — Tue, 27 Jun 2017 17:51:36 GMT

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.

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

art297 — Tue, 27 Jun 2017 18:58:56 GMT

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

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

Rick_SAS — Tue, 27 Jun 2017 19:18:49 GMT

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.

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

Kurt_Bremser — Wed, 28 Jun 2017 05:47:26 GMT

Nice work, @art297!

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

ganeshsas764 — Sun, 02 Jul 2017 08:09:19 GMT

super , Thank you