topic calculate start of month and end of month macro vars in SAS Programming

calculate start of month and end of month macro vars

Ronein — Mon, 04 Sep 2023 21:02:08 GMT

Hello

User define 2 macro variables in format YYMM.

The task is to create 2 more macro variables that are calculated automatically.

What is the way to calculate them please?

First macro var will get value of start of month of From_YYMM

Second macro var will get value of End of month of until_YYMM

/***USer Define macro variables***/
%let From_YYMM=2212;
%let until_YYMM=2307;

/***Macro variables that need to be calculated automatically***/
%let FROM='01DEC2022'd;
%let Until='31JUL2023'd;

Re: calculate start of month and end of month macro vars

Kurt_Bremser — Mon, 04 Sep 2023 21:17:03 GMT

%let from = %sysfunc(inputn(20&from_yymm.01,yymmdd8.));
%let until = %sysfunc(intnx(month,%sysfunc(inputn(20&until_yymm.01,yymmdd8.)),0,e));

Re: calculate start of month and end of month macro vars

mkeintz — Mon, 04 Sep 2023 22:09:22 GMT

I'd suggest:

%let from_date=%sysfunc(putn(%sysfunc(inputn(20&from_yymm.01,yymmdd8.)),date9.));
%let until_date=%sysfunc(putn(%sysfunc(intnx(month,%sysfunc(inputn(20&until_yymm.01,yymmdd8.)),0,e)),date9.));

which will produce macrovars

GLOBAL FROM_DATE 01DEC2022
GLOBAL FROM_YYMM 2212
GLOBAL UNTIL_DATE 31JUL2023
GLOBAL UNTIL_YYMM 2307

I think eliminating the single quotes makes things simpler. FROM_DATE and UNTIL_DATE are human-readable, while allowing this usage in your regular SAS code. Just use double-quotes (which will not mask the value from the macro interpreter) and the trailing letter d.

where date between "&from_date"d and "&to_date"d;