Update dataset (argument to macro) in each do loop inside PROC IML.

[themanoj20080]

Hello everyone,

I have a macro that takes a dataset, and few other as arguments. I am inside a PROC IML. I am using a do loop and inside a do loop, I am calling a macro that I have already created. How can I update the data set in each loop so that updated data set can be used each time in the loop when I call the macro?

[PeterClemmensen]

I can't imagine this.. Can you post your code please?

[Cynthia_sas]

Hi:
There is a separate forum for IML users: https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/bd-p/sas_iml your question might be viewed by more IML users in that forum.
Cynthia

[ballardw]

If your macro contains any PROC or DATA step blocks it will halt the Proc Iml executing when encounter if it doesn't create an error condition.

Just like when I run this code:

Data junk;

   set sashelp.class;

   if sex='F' then weight=weight-1;

proc print data=junk;

run;

The SAS system when it encounters the PROC "knows" that you intended to end the data step and implies a "run;" statement.

Similarly if another Data step definition is encountered the same thing happens with the currently executing data step or proc terminating so the new data step can start.

You would have to post the entire code of the IML attempting to call the macro and the macro definition(s) to see what alternate ideas may be practical.

[themanoj20080]

Here is the example. I have a macro and proc iml. In the PROC IML, after the loop ends I want five different means but I am not getting that.
%macro hello(X);
use &dataset; read all var{&X} into A;
m=mean(A);
print m;
%mend hello;

proc iml;
do i = 1 to 5;
X=randnormal(10,0,1);
firstcol=X[,1];
create newdata var{firstcol};
append;
close;
%let dataset=newdata;
%hello(firstcol);
call delete(dataset);
end;
quit;