topic Re: call a macro inside a macro in SAS Enterprise Guide

call a macro inside a macro

ak2 — Fri, 23 Feb 2018 12:58:51 GMT

Hi. I have a macro where I want to do 2 things if n>0 (else do nothing). I want to append a data set to an existing table, and I want to call for another macro. I get this error message referring to the call of the macro: "Statement is not valid or it is used out of proper order." Can anyone help me?

%macro x;

%if &n.>0 %then %do;

proc append base=a data=b;run;
call execute("%addInfo");
%end;

%mend;

%x;

Re: call a macro inside a macro

PaigeMiller — Fri, 23 Feb 2018 13:05:03 GMT

The call execute is unnecessary here. This ought to work (assuming macro %addinfo is defined).

%macro x;
%if &n.>0 %then %do;
proc append base=a data=b;run;
%addInfo
%end;
%mend;

%x

Re: call a macro inside a macro

ak2 — Fri, 23 Feb 2018 13:16:19 GMT

Thank you! That worked fine.