Macro help creating a rolling 12 months

[This widget could not be displayed.]

Hi,

I need help in creating a macro around my simple query to report a rolling 12 months, anyone able to help me please?

%let mon=%sysfunc(intnx(month,%sysfunc(today()),&i.),yymmn6.);

%do i=1 %to 12;

data pootsDefs;

set mortbib.mort_&mon.(keep=mort snap bal);

run;

[Kalind_Patel]

Try this code:

%macro month;
%do i=1 %to 12;
%let mon=%sysfunc(intnx(month,%sysfunc(today()),&i),yymmn6.);

data work.mort_&mon.;
set sashelp.class;
run;
%end;
%mend;

%month

[RW9]

You can use the search functionality on this forum, there are hundreds of posts on this subject:

https://communities.sas.com/t5/forums/searchpage/tab/message?q=rolling+window