topic Getting the second to last working day in SAS Procedures

Getting the second to last working day

andy_wk — Thu, 31 Jul 2014 15:44:29 GMT

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 — Thu, 31 Jul 2014 16:01:58 GMT

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 — Thu, 31 Jul 2014 16:03:36 GMT

Thank you so much Haikuo !!!