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 (1406 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 (1402 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/

 

 

Become an Explorer! Join SAS Analytics Explorers to learn and complete challenges that earn rewards!
0 Likes
Reply
SASPhile
Quartz | Level 8 SASPhile
Quartz | Level 8

Re: Prxmatch

Posted 01-24-2018 09:46 AM (1385 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

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

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
  • 8008 views
  • 0 likes
  • 4 in conversation