☑ This topic is solved.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 07-31-2022 09:21 PM
(641 views)
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thank you very much! It worked 🙂