Use equivqlent to LIKE in splitter transformation

[Peter_Wine]

Hi All, I'd like to use splitter to split data based on condition: FILED1 NOT LIKE "*abc*" I functions: CONTAINS and LIKE are not available in the functions list. I tried to use operator "=*" but it also doesn't work NOT FIELD1 =* '%abc%' Any advise? regards, Piotr

[RW9]

Please provide an example, or clear text on what your issue is.  Are you saying that you are used to the SQL syntax like?  If so this post might help.

http://support.sas.com/kb/43/303.html

If not, please clarify.

[LinusH · Accepted solution]

The splitter transformation is using a data step, and IF statements, hence WHERE specific syntax is not available.

See this link on how to mimic LIKE and CONTAINS in an IF statement.

https://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=p1cxl8ifdt8u0gn12wqbji8o5fq1.htm&doc...