How to Add and increment the date in MM/DD/YYYY format

Michael Angelo Pagala · Posted: Wed Mar 07, 2007 3:47 pm

Hi!

Can you please help me or teach me how to add/increment a date.

The date is in MM/DD/YYYY format

Sample input
02/27/2007

then I will add any number of days so for this I will add 10 days..

The output must be
03/10/2007

It can be in sort/SAS/Easytrieve

Thanks a lot!
this is my first time to post here so please be kind to me

dick scherrer · Posted: Thu Mar 08, 2007 9:00 am

Hello,

Where is the date (field?) stored?

Is this a control date or do you want to change the date across a file?

Please post what you have and what you would like for a result.

Alan Voss · Posted: Fri Mar 09, 2007 3:12 am

I think you want to add 11 days to get 03/10/2007,

Anyway the SAS solution (two different ways) is:
data indates;
input indate mmddyy10.;
format indate mmddyy10.;
cards;
02/27/2007;
data outdates;
set indates;
increment = 10;
outdate_a = indate+increment;
outdate_b = intnx("DAY",indate,increment);
format outdate_a outdate_b mmddyy10.;
put indate increment outdate_a outdate_b ;
run;

Yielding:
02/27/2007 10 03/09/2007 03/09/2007

Skolusu · Posted: Tue Nov 17, 2009 3:58 am

Michael Angelo Pagala,

With z/OS DFSORT V1R5 PTF UK51706 or z/OS DFSORT V1R10 PTF UK51707, you can use the new date conversion function TOGREG/TOJUL like shown below to get the desired results

Skolusu · 03/09/2007

Michael Angelo Pagala,

With z/OS DFSORT V1R10 PTF UK90025 or z/OS DFSORT V1R12 PTF UK90026 (Oct, 2010), adding number of days is much easier like shown below