Desktop productivity for business analysts and programmers

Write Case Expression to recode variable values into a new column

Accepted Solution Solved
Reply
New Contributor Dru
New Contributor
Posts: 2
Accepted Solution

Write Case Expression to recode variable values into a new column

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


Accepted Solutions
Solution
‎02-19-2015 12:56 PM
Super User
Super User
Posts: 6,851

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

Use IN operator.

CASE

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

   ELSE 'Safety'

END

View solution in original post


All Replies
Solution
‎02-19-2015 12:56 PM
Super User
Super User
Posts: 6,851

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

Use IN operator.

CASE

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

   ELSE 'Safety'

END

New Contributor Dru
New Contributor
Posts: 2

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

Thanks Tom, it worked perfectly!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 308 views
  • 0 likes
  • 2 in conversation