topic SAS Macro inside PROC IML. in New SAS User

SAS Macro inside PROC IML.

themanoj20080 — Wed, 12 Dec 2018 19:13:19 GMT

Hello Everyone,

I am trying to use a macro inside PROC IML and it is giving me an error. Suppose I created a macro named mymacro and I call this macro inside proc iml. I would think 4 will be returned 5 times but it is not. Can anyone explain why this is not working?


%macro mymacro(A,Y=2);
proc iml;
Z=&A+&Y;
print Z;
quit;
%mend mymacro;

proc iml;
do i = 1 to 5;
%mymacro(2);
end;
quit;

Re: PROC IML inside SAS Macro.

SASKiwi — Wed, 12 Dec 2018 19:14:23 GMT

Try this change to your MYMACRO macro. You only need to call PROC IML once:

%macro mymacro(A,Y=2);
Z=&A+&Y;
print Z;
%mend mymacro;

Re: PROC IML inside SAS Macro.

themanoj20080 — Wed, 12 Dec 2018 19:17:23 GMT

Got it. Thank you so much. Is this always the case that I don't have to use PROC IML inside a macro?

Re: PROC IML inside SAS Macro.

SASKiwi — Wed, 12 Dec 2018 19:27:04 GMT

@themanoj20080 - Yes, it depends what you want your macro to do. In your case the macro generates statements inside a single PROC IML step so you leave out PROC IML and QUIT statements.

Another time you might want to run PROC IML multiple times say with slightly different statements - in this case your macro would include PROC IML and QUIT statements.