Sounds Like operator

noobs — Wed, 03 Apr 2013 18:21:17 GMT

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

Reddy

Reddie

Redy

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.

Re: Sounds Like operator

Reeza — Wed, 03 Apr 2013 19:30:09 GMT

=* uses the soundex algorithm

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

=: basically checks if the word starts with the same letters. Case matters, so if it was 'red' you would get no entries returned.

24851 - Using a Colon Modifier to Select Observations with Values Beginning with a Specific Character By Kirk Paul Lafler

topic Sounds Like operator in ODS and Base Reporting

Sounds Like operator

Re: Sounds Like operator