topic Update dataset (argument to macro) in each do loop inside PROC IML. in New SAS User

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

themanoj20080 — Wed, 12 Dec 2018 20:15:28 GMT

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?

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

PeterClemmensen — Wed, 12 Dec 2018 20:34:15 GMT

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

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

Cynthia_sas — Wed, 12 Dec 2018 20:40:49 GMT

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

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

ballardw — Wed, 12 Dec 2018 20:49:25 GMT

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.

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

themanoj20080 — Wed, 12 Dec 2018 21:06:35 GMT

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;