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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: