topic SAS macro variable for the day before the last day of the previous month in SAS Programming

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

Elliott — Wed, 23 Jun 2021 13:25:52 GMT

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,

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

PaigeMiller — Wed, 23 Jun 2021 13:31:12 GMT

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

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

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

Elliott — Wed, 23 Jun 2021 14:02:23 GMT

Thank you very much!