Help using Base SAS procedures

LIKE column name

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

LIKE column name

[ Edited ]

 

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;


Accepted Solutions
Solution
‎07-26-2016 08:33 AM
Super User
Posts: 17,829

Re: LIKE column name

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...

View solution in original post


All Replies
Solution
‎07-26-2016 08:33 AM
Super User
Posts: 17,829

Re: LIKE column name

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...

Occasional Contributor
Posts: 10

Re: LIKE column name

THANK YOU!!!!!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 297 views
  • 1 like
  • 2 in conversation