Calling multiple macros within a data _null_ statement

mgm — Thu, 12 May 2016 15:01:40 GMT

I'm having trouble calling 3 different macros in a sequence within a data _null_ step. Here is a code snippet :

DATA _NULL_;

SET DATES;

if x = 'A' then call execute ('%runA('||rebal||')');

if x = 'B' then call execute ('%runB('||rebal||')');

if x = 'C' then call execute ('%runC('||rebal||')');

run;

Essentially x is in a sequence 'A','B','C','A','B','C','A','B','C','A','B','C'. Since the execute statement runs at the end of the data step there is no guarantee that the three steps are running in the right sequence. steps in %runB depend on %runA to complete and steps in %runC depend on %runB to complete...

Let me know ?

Re: Calling multiple macros within a data _null_ statement

FreelanceReinh — Thu, 12 May 2016 15:27:00 GMT

Hi @mgm,

The late Roland Rashleigh-Berry recommended to mask macro calls in CALL EXECUTE with %NRSTR in order to prevent premature execution: http://www.datasavantconsulting.com/roland/call_exec.html

So, you could try if

if x = 'A' then call execute ('%nrstr(%runA('||rebal||'))');

etc. works better.

topic Re: Calling multiple macros within a data _null_ statement in SAS Enterprise Guide

Calling multiple macros within a data _null_ statement

Re: Calling multiple macros within a data _null_ statement