SAS macro variable for the day before the last day of the previous month

[Elliott]

I need some help with a macro variable that will equal the value of the day before the previous months end date.  I can get previous month end date but how to I create another macro variable for the day before that date?

I have made several attempts but they never resolve to what I need.

Any assistance will be greatly appreciated.

Thank you,

[PaigeMiller · Accepted solution]

data _null_;
    call symputx('day_before',intnx('month',today(),-1,'e')-1);
Run;

%put %sysfunc(putn(&day_before,mmddyy10.));

[Elliott]

Thank you very much!