topic NOT LIKE OPERATOR DOES NOT WORK WITH A LIST in SAS Enterprise Guide

NOT LIKE OPERATOR DOES NOT WORK WITH A LIST

avatar — Thu, 24 May 2018 15:37:55 GMT

I Would like to remove supplies from file. below code does not work. it works only for one supply. when combined , it does not remove .

any other way to remove all at once.

AND (A.PROD_1_DESC NOT LIKE 'ADAPTER%' OR A.PROD_1_DESC NOT LIKE 'AUVI-Q%'

OR A.PROD_1_DESC NOT LIKE 'AVOSTARTGRIP%'

OR A.PROD_1_DESC NOT LIKE 'CATH++%' OR A.PROD_1_DESC NOT LIKE 'CLAVE%'

OR A.PROD_1_DESC NOT LIKE 'CONNECTOR%' OR A.PROD_1_DESC NOT LIKE 'CRONO SYRINGE%'

OR A.PROD_1_DESC NOT LIKE 'DRESSING%' OR A.PROD_1_DESC NOT LIKE 'FILTER%'

OR A.PROD_1_DESC NOT LIKE 'GRIPPER%' OR A.PROD_1_DESC NOT LIKE 'HUBER%'

Please help.

Thanks

Re: NOT LIKE OPERATOR DOES NOT WORK WITH A LIST

ballardw — Thu, 24 May 2018 15:48:35 GMT

You could include all of the code, an example data set that demonstrates the behavior and what you expect the result to be. Best is to post example data in the form of a data step so we can actually test code against your data and to post all code in a code box opened with the forum {I} icon.

When you have "something and (<a bunch of OR comparisons>) the part before the AND is significant as well.

Re: NOT LIKE OPERATOR DOES NOT WORK WITH A LIST

Astounding — Thu, 24 May 2018 16:02:17 GMT

Your logic is incorrect. Change OR to AND.

Re: NOT LIKE OPERATOR DOES NOT WORK WITH A LIST

TomKari — Thu, 24 May 2018 16:14:43 GMT

ANDs and ORs with NOTs are tricky. If you think about it, with

VAR1 NOT LIKE 'A' OR VAR1 NOT LIKE 'B'

if Var1 is 'A', it is not like 'B'. If it's 'B', it's not like 'A'. So you always pass the test.

As suggested above, change OR to AND, or use the structure

NOT (LIKE 'A' OR LIKE 'B' OR LIKE 'C')

Tom

Re: NOT LIKE OPERATOR DOES NOT WORK WITH A LIST

avatar — Fri, 25 May 2018 00:46:46 GMT

Thank you all very much !!!!. Now I understand how this works.