multiple macro variables through a loop

[rajat051984]

I am trying to create some macro variables for multiple months as follows:

%let datep = date();

data _null_;

set b (obs=1);

prv1mnt = put(intnx('month',&datep.,-1,'beginning'),monyy7.);

call symput('prv1mntm',prv1mnt);

prev_1_mon_dt =intnx('month',&datep.,-1,'beginning');

prev_1_mon = year(prev_1_mon_dt)*100 + month(prev_1_mon_dt);

call symput('pr1mn',prev_1_mon);

run;

I need to do the above processing for last 12 months. Can it be done through loop?

[Reeza · Accepted solution]

Not 100% sure what you're asking, but wouldn't a macro do loop work?

%do i=1 %to 12;

%let datep = %sysfunc(intnx(month, %sysfunc(date()), -1*&i, b));

*rest of code;

%end;

[rajat051984]

Thanks Reeza.