topic Re: how can i do this for next 5 years !! in SAS Programming

how can i do this for next 5 years !!

allurai0412 — Sat, 09 Mar 2013 17:34:42 GMT

hi,

I am increementing 'spcday' by one month.....as ' nxt_spcday'.....but while increementing "nxt_spcday' should not a 'SUNDAY'

Till now i did only for one month....how can do this for next 5 years ...?

data have ;

input scheme$ spcday DDMMYY10.;

nxt_spcday=intnx('month',spcday,1,'s');

if weekday(nxt_spcday)=1

then nxt2_spcday=intnx('day',nxt_spcday,1);

FORMAT spcday DDMMYY10. ;

format nxt_spcday ddmmyy10.;

format nxt2_spcday ddmmyy10.;

datalines;

IV 14/03/2013

;

Regards

ALLU

PGStats — Sat, 09 Mar 2013 17:46:28 GMT

Try something like this :

data have;

format spcday nxt_spcday ddmmyy10.;

input scheme$ spcday DDMMYY10.;

do _n_ = 1 to 5*12;

nxt_spcday=intnx('month',spcday,_n_,'s');

if weekday(nxt_spcday)=1

then nxt_spcday=intnx('day',nxt_spcday,1);

output;

end;

datalines;

IV 14/03/2013

;

allurai0412 — Sat, 09 Mar 2013 18:08:16 GMT

Thanks a lot..