topic Re: Macro help creating a rolling 12 months in SAS Programming

Macro help creating a rolling 12 months

anonymous_user — Wed, 25 Jan 2017 10:54:51 GMT

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;

Re: Macro help creating a rolling 12 months

Kalind_Patel — Wed, 25 Jan 2017 11:09:03 GMT

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

Re: Macro help creating a rolling 12 months

RW9 — Wed, 25 Jan 2017 12:36:32 GMT

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