DATA Step, Macro, Functions and more

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

Reply
Occasional Contributor
Posts: 12

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

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"

SAS Super FREQ
Posts: 3,755

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

Posted in reply to ganeshsas764

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.

 

PROC Star
Posts: 7,491

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

[ Edited ]
Posted in reply to ganeshsas764

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

 

SAS Super FREQ
Posts: 3,755

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

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.

Super User
Posts: 7,854

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

Nice work, @art297!

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 12

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

super ,  Thank you 

Ask a Question
Discussion stats
  • 5 replies
  • 227 views
  • 4 likes
  • 4 in conversation