I want to run a macro like this
%macro mymacro(str1, str2);
data want;
set have;
if index(mystring, "&str1") > 0 or index(mystring, "&str2") > 0;
run;
%mend
The problem is that my input strings include cases like " FL", ",C A", ", DE", "G.A."
How can I safely pass these strings into the macro?
Use an appropriate macro quoting funciton. See the blog post Passing comma-delimited values into SAS macros and macro functions by @LeonidBatkhan for a thorough discussion.
Here is the link to that post: Passing comma-delimited values into SAS macros and macro functions .
Probably the easiest way is to include the quote marks in the values you pass. They will then protect the space and the comma. e.g. :
%macro mymacro(str1, str2);
data want;
set have;
if index(mystring, &str1) > 0 or index(mystring, &str2) > 0;
run;
%mend ;
options mprint ;
%mymacro(" FL",",C A")
But certainly doing it via macro quoting will work. And @LeonidBatkhan's blog is a great place to start.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.
Early bird rate extended! Save $200 when you sign up by March 31.
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.
Ready to level-up your skills? Choose your own adventure.