topic Re: Trying to call macro variables inside a do loop in SAS Programming

Trying to call macro variables inside a do loop

deepakg77717 — Mon, 20 Dec 2021 10:03:57 GMT

hi All,

I have created macro variables

%let B1=123;
%let B2=231;

%let B3=8;
Trying to call these inside a do loop.

data one;
array var[3] first second third ;
do j = 1 to 3;
var[j]= &Bj.;
end;
run;

The above code does not work. Please suggest

s_lassen — Mon, 20 Dec 2021 10:30:47 GMT

Macro variables are normally resolved during datastep compilation, so in order to get at them dynamically in a datastep, you will have to use SYMGET:

data one;
  array var[3] 8 first second third ;
  do j = 1 to 3;
    var[j]= input(symget(cats('B',j)),best32.);
    end;
run;

deepakg77717 — Mon, 20 Dec 2021 10:45:08 GMT

Thank you for the reply..It works fine now...