use NOT Like in Case when statement

[Divya12]

Hi everyone,

Can you help me on how to use not like operator in a case when statement. 

 case when ConsumerNumber NOT IN (4* or H* or M* or N* or Q* or R*) then 'Not Selected' Else 'Selected ' end as selectionresult

Thanks

[ballardw]

can you show the LOG you get when running that code? Copy the entire proc step with messages and paste into a code box opened on the forum with the </> icon.

[Divya12]

CODE -
proc sql;
create table method as
select distinct (methodofpayment) as consumernumber ,
case when ((METHODOFPAYMENT) not like "4%") then 'not selected'
when ((METHODOFPAYMENT) not like "H%") then 'not selected'
when ((METHODOFPAYMENT) not like "M%") then 'not selected'
when ((METHODOFPAYMENT) not like "N%") then 'not selected'
when ((METHODOFPAYMENT) not like "Q%") then 'not selected'
else 'selection' end as selectionresult
from TEMP;

THIS IS THE OUTPUT I AM GETTING:

consumernumber selectionresult
HD not selected
SX not selected
91 not selected
S5 not selected
W not selected
5 not selected
H not selected
SQ not selected
ST not selected
HX not selected
H2 not selected

[PGStats · Accepted solution]

case when first(ConsumerNumber) IN ("4", "H", "M", "N", "Q", "R") then 'Selected' Else 'Not Selected ' end as selectionresult