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
deleted_user
deleted_user
Not applicable

SAS approximate string matching, fuzzy search

Posted 04-16-2010 04:15 AM (1845 views)
Hi,

I have two text files A.txt & B.txt

A.txt has 100 observations
B.txt has 200 observations

For every observation in A, I need it to look through every observation in B and return the closest match based on the complev function.

Is there a simple way to do this?
0 Likes
Reply
1 REPLY 1
RussAlbright
SAS Employee RussAlbright
SAS Employee

Re: SAS approximate string matching, fuzzy search

Posted 04-16-2010 09:22 AM (1805 views)  |   In reply to deleted_user
I would create a 2x(100x200) data set with proc sql, and run the complev function, and output the max value by group.

Russ

Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users
0 Likes
Reply

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Watch How to choose a machine learning algorithm on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎04-16-2010 04:15 AM
  • 1846 views
  • 0 likes
  • 2 in conversation