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;
... View more