topic Re: One more variable in DO loop in SAS Programming

One more variable in DO loop

ZZB — Wed, 29 Aug 2018 11:46:00 GMT

%macro m(start=,end=);
proc expand data=A1 (keep=ID date AAA) out=A3 method=none;
%do i=&start %to &end;
by permno;
id date;
convert AAA = AAA_&i / transformout=(reverse MOVPROD &i reverse trimright &j);
%end;
run;
%mend m;
%m(start=2,end=50);

--------------------------------------------------

Here how to code j ? j=i-1

It is incorrect if I just use "&i-1" in the transformout. Thanks!

Re: One more variable in DO loop

Kurt_Bremser — Wed, 29 Aug 2018 11:56:22 GMT

For integer calculations in macro code you need the %eval() macro function.

But do you really want to repeat the statements

by permno;
id date;
convert AAA = AAA_&i / transformout=(reverse MOVPROD &i reverse trimright &j);

49 times in one proc expand?

Re: One more variable in DO loop

Kurt_Bremser — Wed, 29 Aug 2018 12:06:16 GMT

I guess you'd rather want to have this:

%macro m(start=,end=);
proc expand
  data=A1 (keep=ID date AAA)
  out=A3
  method=none
;
by permno;
id date;
%do i=&start %to &end;
convert AAA = AAA_&i / transformout=(reverse MOVPROD &i reverse trimright %eval(&i-1));
%end;
run;
%mend m;
%m(start=2,end=50);