topic Re: Use equivqlent to LIKE in splitter transformation in SAS Data Management

Use equivqlent to LIKE in splitter transformation

Peter_Wine — Wed, 05 Dec 2018 14:32:26 GMT

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

Re: Use equivqlent to LIKE in splitter transformation

RW9 — Wed, 05 Dec 2018 14:50:23 GMT

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.

Re: Use equivqlent to LIKE in splitter transformation

LinusH — Wed, 05 Dec 2018 14:59:50 GMT

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&docsetVersion=9.4&locale=en#n1wc8y12ji18hun175mmicvawb33