04-03-2013 02:21 PM
I am struggling to understand what is better to use as an operator while resolving the requirement to mimic SOUNDS LIKE feature. The data set contains variable Emp_Name that has values like
and output data set needs to filter all these observations. So I can use
WHERE Emp_Name =* 'Red' ;
What is primary difference between =* and =: ?
Very new to Base SAS programming so data cleansing is my challenge.
04-03-2013 03:30 PM
=* uses the soundex algorithm
=: basically checks if the word starts with the same letters. Case matters, so if it was 'red' you would get no entries returned.