Tips:Now You Can Use the IN Operator in a Macro

From sasCommunity
Jump to: navigation, search

Starting in SAS 9.2, you can use the IN operator inside of a macro.

options minoperator;
%macro putme(name=)/mindelimiter=',';
	%if %lowcase(&name) in alice,alfred,barbara %then %put &name is in the list;
	   %else %put name is NOT in the list;
%mend;
 
%putme(name=Alice)
%putme(name=Buddy)

The user must specify both the MINOPERATOR global option, the MINDELIMITER local option within the macro definition, and the delimiter for the MINDELIMETER option.

....see also

Submitted By Mary Rosenbloom (talk)