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 !!!
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 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.