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..
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.