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;
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
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.