This is a simple solution that will work if and only if the values have the same length.
In the example, the search parameter is assumed to be in the beginning of the string.
DATA EMPLOYEES;
LENGTH LASTNAME $9;
INPUT @1 LASTNAME;
cards;
JONES
SMITH
Doe
wesson
CRISCO
;
run;
proc sql number;
select lastname from employees
where upper(substr(strip(lastname),1,3))
in ('SMI', 'WES', 'BRO', 'DOE');
quit;
... View more
