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.
=* 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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.