topic Re: Macro Parameters in SAS Programming

Macro Parameters

alan0101 — Thu, 14 Aug 2014 07:26:23 GMT

Is it possible to specify multiple values for one macro parameter, for example :

%macro Links (ClientId=);

code

%mend Links;

%Links (ClientId=1,2,3,4);

Re: Macro Parameters

user24feb — Thu, 14 Aug 2014 08:00:34 GMT

Sure, you can, but I would not use a comma as a separating character:

%Macro Links(ClientID=);

/* maybe work on a list .. */

%Let i=1;

%Let ID=%Scan(&ClientID.,1,' ');

%Do %While (&ID^=);

%Put **&ID.**;

%Let i=%Eval(&ID.+1);

%Let ID=%Scan(&ClientID.,&i.,' ');

%End;

%Mend;

%Links(ClientID=1 2 3 4);

Re: Macro Parameters

alan0101 — Thu, 14 Aug 2014 08:05:01 GMT

Hmmm, I think I could be missing something here. I am trying to get the macro to iterate once for every value of ClientId, but I am not sure that this is what it was intended for.

Re: Macro Parameters

RW9 — Thu, 14 Aug 2014 08:12:11 GMT

Hi,

So what is it your trying to achieve? You can pass a delimited list of data in as User24feb has mentioned. There is also another syntax for parmbuff which you can pass any number of parameters in. You could also generate the code which is my preference.

data have;

client="ABC"; output;

client="BBD"; output;

run;

data _null_;

set have;

call execute('%Links('||strip(client)||');'); /* Creates a macro call for each row of dataset */

run;

Without knowing exactly what you want to achieve though its hard to provide concrete examples.

Re: Macro Parameters

LinusH — Thu, 14 Aug 2014 08:12:53 GMT

Yes you could, but then you need to parse the parameter and build a %do loop inside the macro.

If you wish to execute the whole macro for each value, you might want to look at calling the macro multiple times instead. If you have many values, you could drive this by storing the values in a data set, and call the macro dynamically by call execute.

Re: Macro Parameters

alan0101 — Thu, 14 Aug 2014 08:35:42 GMT

Basically, I want the macro to iterate for each value of ClientId, something like this (assume there are only 4 ClientID's : 1,2,3,4) :

%macro Links (ClientId=);

code

%mend Links;

%Links (ClientId=1);

%macro Links (ClientId=);

code

%mend Links;

%Links (ClientId=2);

%macro Links (ClientId=);

code

%mend Links;

%Links (ClientId=3);

%macro Links (ClientId=);

code

%mend Links;

%Links (ClientId=4);

Re: Macro Parameters

RW9 — Thu, 14 Aug 2014 08:56:53 GMT

So yes:

%macro Links (ClientId=);

code;

%mend Links;

data have;

do client=1 to 4;

output;

end;

run;

data _null_;

set have;

call execute('%Links (ClientId='||strip(put(client,best.))||');');

run;

Re: Macro Parameters

alan0101 — Thu, 14 Aug 2014 09:12:38 GMT

Thanks RW9, much appreciated

Re: Macro Parameters

alan0101 — Thu, 14 Aug 2014 09:29:19 GMT

Oops, one last thing RW9. Our ClientID's are not in numerical order, so would, for example, be 1,5,7,9. How would I phrase the do loop (where you say do client=1 to 4) to accommodate this ?

Re: Macro Parameters

RW9 — Thu, 14 Aug 2014 09:43:50 GMT

I will also compress the code a bit now you have seen it:

%macro Links (ClientId=);

code;

%mend Links;

data have;

do client=1,5,7,9;

call execute('%Links (ClientId='||strip(put(client,best.))||');');;

end;

run;

Re: Macro Parameters

alan0101 — Thu, 14 Aug 2014 09:47:07 GMT

Thanks again - perfect !

Re: Macro Parameters

Ksharp — Thu, 14 Aug 2014 12:55:27 GMT

Use minoperator

%macro Links (ClientId=) / minoperator ;

%if &ClientId in 1 2 3 4 %then %do ;

code

%mend Links;

%Links (ClientId=1 )

%Links (ClientId=2 )

%Links (ClientId=12 )

Xia Keshan