topic Re: Repeating a Compiled Macro? in SAS Programming

Repeating a Compiled Macro?

bnarang — Mon, 05 Nov 2012 04:32:55 GMT

Hi All

I am not sure whether it was answered before in this community. (Sorry for duplicating). The question is:

If I have a macro with some parameters like this:

%Macro have( A = , B =, C = , D 😃

Program goes here...

%Mend

Now, I want to execute this program many times in the program with different set of parameters

%Have ( A = 1 , B = 2 , C = 3, D = 4);

%Have ( A = 3, B = 3 , C =9, D = 6);

.....................................................

......................................................

This look litte ugly to me as repeating a macro progam. Are there other ways where we can produce the same results but looks nice.

Thank you

Linlin — Mon, 05 Nov 2012 04:42:52 GMT

Is this better?

%Macro have( A , B , C , D )

Program goes here...

%Mend

Now, I want to execute this program many times in the program with different set of parameters

%Have ( 1 , 2 , 3, 4)

%Have (3, 3 , 9, 6)

...................................................

Ksharp — Mon, 05 Nov 2012 05:07:22 GMT

You can use a dataset to hold these parameter, then call execute them.

data x;

input a b c d;

cards;

1 2 3 4

3 3 9 6

;

run;

data _null_;

set x;

call execute( '%have(' || a || ',' || ....................... );run;