topic Re: Create macro vars End and Start dates from YYMM macro var in SAS Programming

Create macro vars End and Start dates from YYMM macro var

Ronein — Mon, 12 Jul 2021 12:29:28 GMT

Hello

User define a macro variable with structure YYMM (for example: 2107 means month 7 in year 2021).

From this Macro variable I want to calculate 2 new macro variables: Start and End that will represent start date of month and end date of month.

For example:

%let YYMM=2107;

Macro variable called start will get value : '01JUL2021'd

Macro variable called end will get value : '31JUL2021'd

What is the way to calculate macro variables start and End please?

Re: Create macro vars End and Start dates from YYMM macro var

esjackso — Mon, 12 Jul 2021 13:48:58 GMT

Is this what you need? It assumes the year has to be in 2000s ... the various put statements are just to show what each step does. Also assumes you actually want the date token in the macro variable

%let YYMM=2107;

data _null_;
format start end mmddyy10.;
year = 20 || substr("&yymm",1,2);
mon = substr("&yymm",3,2);
put year= ;
put mon= ;

start = mdy(mon,1,year);
put start=;

end = intnx('month',start,0,'end');
put end=;

call symputx('startm',"'"||put(start,date9.)||"'d");
call symputx('endm',"'"||put(end,date9.)||"'d");
run;

%put Startm= &startm;
%put endm= &endm;

Re: Create macro vars End and Start dates from YYMM macro var

Tom — Mon, 12 Jul 2021 13:59:32 GMT

Do you just need values you can uses in code?

%let start=%sysfunc(inputn(20&yymm.01,yymmdd8));
%let end=%sysfunc(intnx(month,&start,0,e));

Or do you need values that humans will recognize?

%let start="%sysfunc(inputn(20&yymm.01,yymmdd8),date9)"d;
%let end="%sysfunc(intnx(month,&start,0,e),date9)"d;

Example:

366   %let YYMM=2107;
367   %let start=%sysfunc(inputn(20&yymm.01,yymmdd8));
368   %let end=%sysfunc(intnx(month,&start,0,e));
369   %put &=yymm &=start &=end;
YYMM=2107 START=22462 END=22492
370
371   %let start="%sysfunc(inputn(20&yymm.01,yymmdd8),date9)"d;
372   %let end="%sysfunc(intnx(month,&start,0,e),date9)"d;
373   %put &=yymm &=start &=end;
YYMM=2107 START="01JUL2021"d END="31JUL2021"d

PS Why are you using only 2 digits for year? I hardcoded the "20" part for the century This will make sure that future dates like 2050 are not translated as 1950 based on your settings for year cutoff.

Re: Create macro vars End and Start dates from YYMM macro var

ballardw — Mon, 12 Jul 2021 14:43:40 GMT

This question is very close to one of your similar questions from 3 years ago.

https://communities.sas.com/t5/SAS-Programming/Define-the-following-parameter-of-dates-YYMM/m-p/443654#M111016