topic Re: Get consecutive months using Date Prompt in SAS Enterprise Guide

Get consecutive months using Date Prompt

madara155 — Mon, 01 Aug 2022 01:21:01 GMT

I am using a Date prompt to get a month and year (the macro has the values in DDMMMYY format eg: 01JAN2022).

Can someone help me to find a way to obtain the next month and the previous month?

Thanks in advance

Re: Get consecutive months using Date Prompt

SASKiwi — Mon, 01 Aug 2022 01:51:18 GMT

Here is one way that is easy to follow:

%let MyDate = 01Jan2022;

data _null_;
 Next_Month = intnx('MONTH', "&MyDate"d, 1, 'BEGINNING');
 Last_Month = intnx('MONTH', "&MyDate"d, -1, 'BEGINNING');
 format Next_Month Last_Month date9.;
 call symputx('Next_Month',  put(Next_Month,date9.)); 
 call symputx('Last_Month',  put(Last_Month,date9.)); 
 put _all_;
run;

%put Next_Month = &Next_Month;
%put Last_Month = &Last_Month;

Re: Get consecutive months using Date Prompt

madara155 — Mon, 01 Aug 2022 02:08:49 GMT

Thank you very much! It worked 🙂