I'm trying to get the second to last working day of any month , regardless of the holidays.
I've tried with that code but I got stuck especially with the intnx
, which is giving me the last day...
data tata; test=today();
put test=;
run;
data toto;
set tata;
lastDay=intnx('month',"test"d,0,'E');
format lastDay ddmmyy10.;
run;
I'm welcoming any tips that will unlock me.
You already have the last day of the month, now you only need to count back one 'working day':
data toto;
lastDay=intnx('weekday',intnx('month',date(),0,'E'),-1);
format lastDay ddmmyy10.;
run;
Haikuo
You already have the last day of the month, now you only need to count back one 'working day':
data toto;
lastDay=intnx('weekday',intnx('month',date(),0,'E'),-1);
format lastDay ddmmyy10.;
run;
Haikuo
Thank you so much Haikuo !!!
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.