Is there an equivalent to the Contains function in SAS Hadoop?

Is there an equivalent to the Contains function in SAS Hadoop (explicit SQL Pass through) ?
WHEN my.DESCRIPTION NOT CONTAINS "ZZZ"

I tried:
When (array_contains(my.DESCRIPTION ,'ZZZ') = FALSE)
It did not work. Any Suggestion?
Thanks in advance.

Tagged:
Sign In or Register to comment.