Help on Levenshtein function

[Kalai2008]

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]

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

[ballardw]

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

[Kalai2008]

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