topic Re: Running macros in sequence dynamically! in SAS Programming

Running macros in sequence dynamically!

lyton80 — Fri, 23 May 2014 18:48:38 GMT

Hello all;

I have 8 macros to run in sequence. It is imperative that one completes before the other starts.

The macros would be run on 10 datasets with names that increase by 1.

How can I do this in a %Macro do loop while ensuring that one macro completes before the other starts?

Thanks in advance.

Stan.

Re: Running macros in sequence dynamically!

Reeza — Fri, 23 May 2014 19:50:51 GMT

How are you calling them currently?

I believe the default behaviour is to wait for one process to finish before starting others, so unless you change something that's what will happen.

Re: Running macros in sequence dynamically!

FriedEgg — Fri, 23 May 2014 22:04:15 GMT

Statements entered in SAS are executed sequentially, so you shouldn't have any real concerns about the process flow (of course there are exceptions, but I would not believe any of them apply here at a novice level).

*list the macro's sequentially;

%mymacro1

%mymacro2

%mymacro3

%myfourthmacro

...

%mymacro10

%myothermacro

*call macro's from a macro with same name plus numerical suffix;

%macro mymacrocaller;

%do i = 1 %to 10;

%let lmacname = mymacro&i;

%&lmacname

%end;

%mend;

%mymacrocaller

*call list of macro's when names are different;

%macro mymaccall;

%let maclist=mymac1 secondone lastone;

%do i = 1 %to %sysfunc(countw(&maclist));

%let lmacn=%scan(&maclist,&i);

%&lmacn

%end;

%mend;

*call list of macro's from a datastep;

data _null_;

infile cards;

input macname $;

call execute(cats('%nrstr(%',macname,')'));

cards4;

mymacro1

foobar

lasagna

;;;;

There are plenty of other ways to do it as well, but the exact problem is not completely apparent from your question.