topic Re: multiple macro variables through a loop in SAS Programming

multiple macro variables through a loop

rajat051984 — Sat, 28 Feb 2015 19:35:50 GMT

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 — Sat, 28 Feb 2015 19:47:01 GMT

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 — Sat, 28 Feb 2015 20:18:13 GMT

Thanks Reeza.