topic How to change YYYYMM to YYYYMMDD where DD is the last day of the month in SAS Programming

How to change YYYYMM to YYYYMMDD where DD is the last day of the month

mhoward2 — Wed, 04 Aug 2021 19:51:48 GMT

So I have this code that defines a variable:

%LET Inc_Start = &&&Inc_Start_YYYY..&Inc_Start_MM;

Whenever I use this, the variable works exactly as it should and I get the exact YYYYMM. However I want to be able to actually get YYYYMMDD where the DD is just the last day of the month. I currently am trying something like this:

%LET Inc_Start = %sysfunc(intnx(month, &&&Inc_Start_YYYY..&Inc_Start_MM, 0, e));

But this gives me the following log output:

87         %PUT &Inc_Start;
SYMBOLGEN:  Macro variable INC_START resolves to 202130

You can see that is YYYYDD and it skips the MM inbetween them! Any ideas? Thanks!

Re: How to change YYYYMM to YYYYMMDD where DD is the last day of the month

Kurt_Bremser — Wed, 04 Aug 2021 20:00:21 GMT

So you first need to convert the YYYYMM to a SAS date before you can use it in the INTNX function.

%LET Inc_Start = &&&Inc_Start_YYYY..&Inc_Start_MM;
%let inc_start = %sysfunc(intnx(month,%sysfunc(inputn(&inc_start.,yymmn6.)),0,e),yymmddn8.);

Untested, posted from my tablet.

For tested code, we would need to know the contents of the macro variables you use.

Re: How to change YYYYMM to YYYYMMDD where DD is the last day of the month

mhoward2 — Wed, 04 Aug 2021 20:13:01 GMT

Thank you very much! I greatly appreciate the help!