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

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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
  • 909 views
  • 0 likes
  • 3 in conversation