topic Re: Display date diff as date in SAS Programming

Display date diff as date

Q1983 — Fri, 19 Feb 2016 16:07:46 GMT

I have seen posts regarding use of the date diff function.

1. I need to take a date say a variable called my_date, add 5 years to it (ie the my_date is always hardcoded on the 1st, 9/1/2010) 5 years from that date is 9/1/2015

2 Now I need to take that resulting date of 9/1/2015 and add 14 days to display if as 9/15/2015 as I always want the 15th of the month

3 Finally I need to subtract 4 months and show a final my_date as 5/15/2015

Re: Display date diff as date

ballardw — Fri, 19 Feb 2016 16:15:32 GMT

Look at the function INTNX. Your requirements would require 3 calls to the function.

Re: Display date diff as date

Reeza — Fri, 19 Feb 2016 16:18:00 GMT

1. INTNX with Year -> intnx('year', date, 5, 's')

2. INTNX with Day (or just add 14)-> intnx('day', date, 14)

3. INTNX with Month -> intnx('month', date, -4, 's')

So, use the INTNX function to calculate your dates.

data want;
date1=mdy(9, 1, 2010);
date2=intnx('year', date1, 5, 's');
date3=intnx('day', date2, 14);
date4=intnx('month', date3, -4, 's');
format date: date9.;
run;

proc print;run;

Re: Display date diff as date

Ksharp — Mon, 22 Feb 2016 03:24:16 GMT

data want;

date1=mdy(9, 1, 2010);

date2=intnx('year', date1, 5, 's');

date3=intnx('day', date2, 14);

date4=intnx('month', date3, -4, 's');

date5=intnx('month', date1, 5*12, 'm');

format date: date9.;

run;

proc print;run;