DATA Step, Macro, Functions and more

type of parameters passed to macro function

Reply
Contributor
Posts: 25

type of parameters passed to macro function

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

Respected Advisor
Posts: 3,156

Re: type of parameters passed to macro function

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

Trusted Advisor
Posts: 1,228

Re: type of parameters passed to macro function

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

Super User
Posts: 10,023

Re: type of parameters passed to macro function

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

Super User
Super User
Posts: 7,039

Re: type of parameters passed to macro function

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;




Super User
Super User
Posts: 7,942

Re: type of parameters passed to macro function

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.

Ask a Question
Discussion stats
  • 5 replies
  • 289 views
  • 0 likes
  • 6 in conversation