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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.