BTW: Use the macro to search for multiple keywords. Use SAS Array processing if searching multiple variables for the same keywords.
And of course: You can also combine the two approaches by wrapping the macro calls into a do loop over an array for searching multiple variables for the same and then have multiple such do loops for different search terms.
...or even have an outer loop which passes in the different search terms.
This is such a beautiful piece of code
Thanks for all the help, much appreciated
Kind regards
If your real data can also contain commas and quotes then eventually add first a TRANSLATE() function and replace commas and quotes with blanks from your string.
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.