In a simple SQL like below, the IN performs a full match against a
given list.  What about if I want to partially match by the first
digits only, as we do LIKE 'abc%' on single case basis?

Should I use substr(name,1) in (select name from c)? Or any other ways
in SQL?  Thanks!

*================;
proc sql;
	create table b as
		select id, name
		from a
		where name in (select name from c)		                order by id;
quit;