Well, I still don't see why filter is in a macro variable, easier to put these type of data elements in a dataset - thats what datasets are for. However per your guidance, this should work:
%let filter_1 = CREATIVE INDUSTRY;
data courses;
length course_long_name $200;
course_long_name="Creative Writing"; output;
course_long_name="Creative Industry"; output;
course_long_name="Creative and Cultural Industry"; output;
course_long_name="Creative Media"; output;
run;
data want;
set courses;
found=0;
do i=1 to countw("&filter_1.");
if index(upcase(course_long_name),scan("&filter_1.",i," ")) > 0 then found=found+1;
end;
if found=countw("&filter_1.") then result="Found";
run;
... View more
