SAS Macro inside PROC IML.

[themanoj20080]

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;

[SASKiwi · Accepted solution]

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;

[themanoj20080]

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

[SASKiwi]

@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.