Tag: functions

Fuzzy Matching

The term “fuzzy matching” describes a method of comparing two strings that might have slight differences, such as misspelling or a middle initial in a name included or not included. One of my favorite functions to compare the “closeness” of two strings is the SPEDIS (spelling distance) function. Have you […]

Fuzzy Matching was published on SAS Users.

Functions can be used in fuzzy match

SOUNDEX (Sound Alike)Ignore case, embedded blanks and punctuations; works best with English-sounding names;Example:WHERE varx = * “Michael”;SPEDIS (Spelling Distance)Translating a keyword into a query containing the smallest value distance;Example:Sped…

NOTE: More on Date Increments (INTCK and INTNX)

It’s always encouraging to get feedback about my blog articles and/or see an article spark some conversation. Last week’s Date Increments (INTNX and INTCK) featured the INTNX function for incrementing (or decrementing) date, time, and datetime values b…

NOTE: Writing Your Own Functions

Did you ever hear of PROC JLAUNCH? No, neither did I until I tried the FCmp Function Editor. And, if you didn’t know, the FCmp Function Editor is an interactive tool for exploring and maintaining functions created with PROC FCMP. There are a lot of goo…