topic Run macro on multiple VARS in SAS Programming

Run macro on multiple VARS

Ronein — Sat, 13 Sep 2025 05:46:58 GMT

Hello

Lets say I have list of variables names in a macro variable separated by '+'.

Lets say that I want to run macro that run on each of the variables.

What is the way to do it please via code that do it automatically?

%let numeric_Vars=
a_Shir_SmlHov_Pigur+
a_Shir_AKM_HZRHIUV+
a_Shir_Vetek_age_Balut+
a_CDO_ExCC_mx_pos_prob
;


/**Want to run this***/
%inf_value(ttt,information_value,a_Shir_SmlHov_Pigur,Ind_Failure);
%inf_value(ttt,information_value,a_Shir_AKM_HZRHIUV,Ind_Failure);
%inf_value(ttt,information_value,a_Shir_Vetek_age_Balut,Ind_Failure);
%inf_value(ttt,information_value,a_CDO_ExCC_mx_pos_prob ,Ind_Failure);

Re: Run macro on multiple VARS

Kurt_Bremser — Sat, 13 Sep 2025 06:39:04 GMT

In a DATA step, run a DO loop over the string containing the macro value (use COUNTW to detrrmine the number of iterations). Use SCAN to extract the single variable names.

Either use CALL EXECUTE to call the macro, or write the code to a temporary file for a later %INCLUDE.

Re: Run macro on multiple VARS

Ksharp — Sun, 14 Sep 2025 06:43:55 GMT

You need make a macro to repeat %inf_value() .

%macro inf_value(ttt,information_value,numeric_Vars,Ind_Failure);
%put &numeric_Vars.;
%mend;





%let numeric_Vars=
a_Shir_SmlHov_Pigur+
a_Shir_AKM_HZRHIUV+
a_Shir_Vetek_age_Balut+
a_CDO_ExCC_mx_pos_prob
;

%macro repeat(let);
%do i=1 %to %sysfunc(countw(&let.,+));
%let temp=%scan(&let.,&i,+);
%inf_value(ttt,information_value,&temp.,Ind_Failure);
%end;
%mend;
%repeat(&numeric_Vars.)

Re: Run macro on multiple VARS

Tom — Sun, 14 Sep 2025 20:19:42 GMT

You could use one of the methods you just learned for parsing the macro variable.

A data step for example:

data _null_;
  do i=1 to to countw("&numeric_Vars",'+');
    call execute('%nrstr(%inf_value)(ttt,information_value,'
      ||scan("&numeric_vars",i,'+')
      ||',Ind_Failure)'
    );
  end;
run;

But perhaps the code that macro is generating using that third positional parameter is something that can accept multiple variables? For example if the macro definition as something like:

%macro inf_value
(parm1 /* ttt */
,parm2 /* information_value */
,parm3 /* numeric variable */
,parm4 /* Ind_Failure */
);
proc reg dataset=analysis_set_&parm1 ;
   where group ="&parm2";
   model &parm4 = &parm3 ;
run;
%mend inf_value;

Then you could call with something like:

%inf_value(ttt,information_value
,a_Shir_SmlHov_Pigur
 a_Shir_AKM_HZRHIUV
 a_Shir_Vetek_age_Balut
 a_CDO_ExCC_mx_pos_prob
,Ind_Failure);

And it might make sense.

In that case it would be better to use space instead of + as the delimiter between the variable names.

If not you could possible modify the macro to add a %DO loop to loop over the list of values.

%macro inf_value(parm1,parm2,parm3_list,parm4);
%local i parm3 ;
%do i=1 %to %sysfunc(countw(&parm3_list,+));
  %let parm3=%scan(&parm3_list,&i,+);
/* body of the original macro */
%end;
%mend inf_value;

In which case you could call it with your list substituted into the third positional parameter.

%inf_value(ttt,information_value,&numeric_vars,Ind_Failure);

And if you cannot modify the macro then make a new macro so you can have it run the %DO loop and generate the calls to the original macro.

Re: Run macro on multiple VARS

yabwon — Mon, 15 Sep 2025 07:51:38 GMT

Use the MacroArray package.

1) Documentation

2) Article

%macro inf_value(ttt,information_value,numeric_Vars,Ind_Failure);
%put [&sysmacroname.] &numeric_Vars.;
data _null_;
  &numeric_Vars.=42;
  put _all_;
run;
%mend;




%loadPackage(macroArray)

/* macroarray */
%array(varsList[*] a_Shir_SmlHov_Pigur a_Shir_AKM_HZRHIUV a_Shir_Vetek_age_Balut a_CDO_ExCC_mx_pos_prob
,vnames=Y
,macarray=Y)

/* loop over macroarray calling %inf_value() macro */
%do_over(varsList,phrase=%nrstr(
  %inf_value(ttt,information_value,%varsList(&_i_.),Ind_Failure);  
))

/* clean up after using macroarray */
%deleteMacArray(varsList,macarray=Y)

Bart