topic Re: use NOT Like in Case when statement in New SAS User

use NOT Like in Case when statement

Divya12 — Wed, 08 Apr 2020 19:49:05 GMT

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

Re: use NOT Like in Case when statement

ballardw — Wed, 08 Apr 2020 20:01:00 GMT

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.

Re: use NOT Like in Case when statement

Divya12 — Wed, 08 Apr 2020 20:09:30 GMT

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

Re: use NOT Like in Case when statement

PGStats — Wed, 08 Apr 2020 20:10:26 GMT

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