CODEWITHSUNDEEP
sas
Mobix
Mobix

Reputation: 103

SAS increment macro variable yyyymm by 1 month

Basically i'm trying to get the below month4 but in a macro format.

Been a while since i've done macro functions so this is a bit tricky.

data test;
    input month $8.;
    datalines ;
202210
202211
202201
202210
    ;
run;



data test2;
    set test;
    format month2 date9. month3 date9.;
    test = cats(month,"01");

    month2 = input(cats(month, "01"), yymmdd8.);
    month3 = intnx("month",input(cats(month, "01"), yymmdd8.),-1);
    month4=trim(substr(put(month3,yymmddn8.),1,6));
run;

Upvotes: 0

Views: 670

Answers (1)

Tom
Tom

Reputation: 51566

I suspect this is what you are looking for, but your request is not very clear.

%let month=202212;
%let month4=%sysfunc(intnx(month,%sysfunc(inputn(&month,yymmn6)),1),yymmn6);

It uses the INPUTN() function to convert your YYYYMM string by reading it with the YYMMN6. informat. It then uses the INTNX() function to move to the beginning of the next month and returns the result formatted with YYMMN format so you get back another YYYYMM string of digits.

Upvotes: 2

Related Questions