topic Re: call execute ('proc print data=dataset; run';) getting executed three times in SAS Programming

call execute ('proc print data=dataset; run';) getting executed three times

mathewse111 — Wed, 23 Jun 2021 20:21:07 GMT

Hi,

I am trying to sent an email with the proc print output of multiple small datasets.

data_null_;

set t1 obs=n1;

if n1 >0 then

call execute (' proc print data=t1; run;');

run;

one of the datasets is getting printed twice. I have removed mlogic from options after refering the web.

Please help.

Elizabeth

Reeza — Wed, 23 Jun 2021 20:23:05 GMT

How many observations do you have in T1? It would print the data t1 for every row in the data set based on that code.

WarrenKuhfeld — Wed, 23 Jun 2021 20:53:27 GMT

@Reeza is right. Add a STOP statement before your RUN statement.

mathewse111 — Wed, 23 Jun 2021 21:03:06 GMT

Thanks a lot. That worked