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
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
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);
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 ......
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;
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.