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
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
;
PG
Thanks a lot..
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.