Write Case Expression to recode variable values into a new column

Dru — Thu, 19 Feb 2015 17:51:41 GMT

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

Re: Write Case Expression to recode variable values into a new column

Tom — Thu, 19 Feb 2015 17:56:52 GMT

Use IN operator.

CASE

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

ELSE 'Safety'

END

Dru — Thu, 19 Feb 2015 18:06:49 GMT

Thanks Tom, it worked perfectly!