Need some help with PROC SQL - Joining tables w/ partially matching data.
Basically I have two tables which I wanted to join/merge into a new table.
However the data are of partial match i.e. AMATA and AMAT or PTTEP and PTTE
While some matches 100% like STEC and STEC
I want to join Table_1 & Table_2 into Table_3.
However, the data only partially matches.
Is it possible to Join using "LIKE"
or use wildcards like % when specifying the join criteria?