LIKE column name

jmckenzie — Mon, 25 Jul 2016 20:06:56 GMT

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;

Re: LIKE column name

Reeza — Mon, 25 Jul 2016 20:42:16 GMT

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#p0a62rd151ctown1x38ihdpjozyv.htm

Re: LIKE column name

jmckenzie — Mon, 25 Jul 2016 21:08:02 GMT

THANK YOU!!!!!

topic LIKE column name in SAS Procedures

LIKE column name

Re: LIKE column name

Re: LIKE column name