BookmarkSubscribeRSS Feed
sr13
Calcite | Level 5

Hi,

I am trying to find out meaning less names or texts in the data(each day i am checking millions of records). Let's say i am checking the weird names in the hotel names.I want to find out names that does not make any sense like xsedzfse ,.... I understand there are few packages that we can install in python/R.   Is there a way to find a resolution to the above issue using SAS.

 

Thanks.

2 REPLIES 2
Reeza
Super User
How does one know that a specific value is meaningless? If the logic is clear, the implementation is easy. So, there is likely a way.
PGStats
Opal | Level 21

Do you have a list of meaningful names and texts?

 

If so, you could use the spelling distance functions provided by SAS. You could speed things up by restraining the computation of spelling distances to words that are not already in your list of meaningful names and only between words starting with the same letter.

 

hth

PG

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

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 835 views
  • 0 likes
  • 3 in conversation