topic Re: Help on the code in SAS Programming

Help on Levenshtein function

Kalai2008 — Fri, 24 Jul 2020 23:27:45 GMT

Hi,

I am trying to get the percentage using the levenshtein function, but the code is not working in SAS.

(x1-x2)/x1

(maX(length(stringa), length(stringb)) - levenshtein(stringa, stringb))) /

max(length(stringa),length(stringb)) as lev_perc

PS: I need to run the program in EAP hive using SAS, so i need to use the function that is compatible to hive too.

Thanks for checking

ChrisHemedinger — Fri, 24 Jul 2020 22:41:02 GMT

Maybe you want the COMPGED function, which is the Levenshtein distance in SAS.

ballardw — Fri, 24 Jul 2020 22:55:19 GMT

It think that should be COMPLEV function if you want the specific Levenshtein distance.

Kalai2008 — Sat, 25 Jul 2020 23:45:40 GMT

Thanks, I have tried both functions and not working.

COMPGED(stringa, stringb) AS VALUE1,

COMPLEV(stringa, stringb) AS VALUE2,

ERROR: Prepare error: Error while compiling statement: FAILED: SemanticException [Error 10011]: Line 1:53 Invalid

function 'COMPGED'

ERROR: Prepare error: Error while compiling statement: FAILED: SemanticException [Error 10011]: Line 1:53 Invalid

function 'COMPLEV'

May be its not working in Hive EAP