LIKE column name

[jmckenzie]

Hi, I'm trying to use the LIKE condition to check for LIKE last names, but I can't get it to work.  I want it to match for names like Tombleson and Tomblesom, Ng and NG, Olm-Shimpan and Olm Shipman, and Hose Aldana and Aldana.  Any suggestions? THANK YOU! 

proc sql;
UPDATE RawData
SET Timesheet_Approver = (SELECT Timesheet_Approver
                FROM MasterStudent
                WHERE MasterStudent.Position__=RawData.PositionNbr
                AND MasterStudent.Last_Name like "%" || RawData.Last_Name || "%")
WHERE EXISTS (SELECT 1
                FROM MasterStudent
                WHERE MasterStudent.Position__= RawData.PositionNbr
                AND MasterStudent.Last_Name like "%" || RawData.Last_Name || "%");
                quit;

[Reeza · Accepted solution]

Try the following instead:

=* is sounds like operator

MasterStudent.Last_Name =* RawData.Last_Name

http://support.sas.com/documentation/cdl/en/sqlproc/69049/HTML/default/viewer.htm#p0a62rd151ctown1x3...

[jmckenzie]

THANK YOU!!!!!