SAS Enterprise Guide

Desktop productivity for business analysts and programmers
BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
madara155
Obsidian | Level 7

Hi

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

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

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;

View solution in original post

2 REPLIES 2
SASKiwi
PROC Star

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;
madara155
Obsidian | Level 7

Thank you very much! It worked 🙂

 

sas-innovate-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Early bird rate extended! Save $200 when you sign up by March 31.

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 642 views
  • 2 likes
  • 2 in conversation