cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
ChrisNZ
Tourmaline | Level 20 ChrisNZ
Tourmaline | Level 20

Re: Prxmatch

Posted 01-23-2018 04:11 PM (548 views)  |   In reply to SASPhile

I'll ask again.

Have you looked at the spelling distance functions? like SPEDIS or COMPGED? 

0 Likes
Reply
ChrisHemedinger
Community Manager ChrisHemedinger
Community Manager

Re: Prxmatch

Posted 01-23-2018 04:17 PM (544 views)  |   In reply to ChrisNZ

To build on @ChrisNZ's suggestion, check out this fuzzy matching tip from @Ron_Cody:

 

https://blogs.sas.com/content/sastraining/sas-authors-tip-spedis-and-fuzzy-matching/

 

 

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
0 Likes
Reply
SASPhile
Quartz | Level 8 SASPhile
Quartz | Level 8

Re: Prxmatch

Posted 01-24-2018 09:46 AM (527 views)  |   In reply to ChrisNZ

Yes, they both are giving  me the desired output.

I tried where soundex(a.text)=soundex(b.text), this did not yeild the result as well. Many of the words between the two strings match. Yet soundex fails.

0 Likes
Reply

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 17 replies
  • ‎01-23-2018 03:11 PM
  • 3563 views
  • 0 likes
  • 4 in conversation