topic type of parameters passed to macro function in SAS Programming

type of parameters passed to macro function

Peter_Y — Fri, 11 Apr 2014 19:58:01 GMT

Hello all:

I need a macro with the functionality to accept both numeric and list as parameters. What I need is sth. like

%macro check(value, var);

%if &value is list %then %do ......

%if &value is a single number %then %do ......

%mend;

so I can call the macro function either

%check(10,measure);

%check((1,2,3,4,5), measure);

Any suggestion on this?

Thanks,

Peter

Re: type of parameters passed to macro function

Haikuo — Fri, 11 Apr 2014 20:37:00 GMT

Maybe I took your question too simple, isn't just adding a quote?

%macro test (VALUE,measure);

%if &value="1,2,3" %then %put &MEASURE.;

%mend;

%test("1,2,3",SUCCESS!);

Haikuo

Re: type of parameters passed to macro function

stat_sas — Fri, 11 Apr 2014 20:54:11 GMT

This is my try

data have;

do measure=1 to 10;

output;

end;

run;

%macro check(value, var);

proc means data=have (where=(&var in (&value)));

var &var;

run;

%mend;

%check (10,measure);

%check (7 8 9,measure);

Re: type of parameters passed to macro function

Ksharp — Sat, 12 Apr 2014 01:44:27 GMT

You can use IN in macro . details check documentation. I can't remember too much.

%macro check(value, list)/mindelimiter=, ;

%if &value in &list %then %do ......

Re: type of parameters passed to macro function

Tom — Sat, 12 Apr 2014 02:35:48 GMT

Just use spaces as the delimiter in the value of the parameter. If you need commas in the code that the macro is generating you always put them in later.

%check(10,measure);

%check(1 2 3 4 5, measure);

%macro check(value, var);

%if %sysfunc(countw(&value,%str( )) > 1 %then %do; ... %end;

%else %do; ...... %end;

%mend;

Re: type of parameters passed to macro function

RW9 — Mon, 14 Apr 2014 10:15:34 GMT

Just to note on the above very good examples, there is one element of macro functionality which does come up much. It is described in this article: http://www.lexjansen.com/pharmasug/2006/technicaltechniques/tt28.pdf

So you could change your macro slightly to:

%macro check (var) / pbuff;

Then scan the syspbuff variable. Just another option.