type of parameters passed to macro function

[Peter_Y]

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

[Haikuo]

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

[stat_sas]

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);

[Ksharp]

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 ......

[Tom]

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;

[RW9]

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.