Getting the second to last working day

[andy_wk]

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.

[haikuobian · Accepted solution]

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

[andy_wk]

Thank you so much Haikuo !!!