Write Case Expression to recode variable values into a new column

[Dru]

Hi,

I'm have a question on syntax here.

I want to classify each of seven variable values into one of two values and place the new values in a new column.

I have success with the following syntax:

CASE 

   WHEN t1.'MEMBER CATEGORY DESC'n = 'Miscellaneous' then 'Non-Safety'

   WHEN t1.'MEMBER CATEGORY DESC'n = 'State Miscellaneous' then 'Non-Safety'

   WHEN t1.'MEMBER CATEGORY DESC'n = 'State Industrial' then 'Non-Safety'

   ELSE 'Safety'

END

Can I roll the conditions into one WHEN statement and one THEN statement, for example:

CASE 

   WHEN t1.'MEMBER CATEGORY DESC'n = ('Miscellaneous' or 'State Miscellaneous' or 'State Industrial') then 'Non-Safety'

   ELSE 'Safety'

END

It doesn't work, but could it work with different syntax?

Thanks for your help.

Dru

[Tom · Accepted solution]

Use IN operator.

CASE

   WHEN t1.'MEMBER CATEGORY DESC'n IN ('Miscellaneous' , 'State Miscellaneous' , 'State Industrial') then 'Non-Safety'

   ELSE 'Safety'

END

[Dru]

Thanks Tom, it worked perfectly!