2 Replies Latest reply on Oct 12, 2015 7:32 AM by mindy.hoftender.0

    Dummy variable to categorical without a HUGE If/Then statement

    mindy.hoftender.0

      Hi all,

       

      I have an age variable that is binary 0/1 for 0-100 that I would like to be a number in an age variable.

      Example:

      Capture.PNG

       

      Now, I can do this with a huge if/then statement for every single age...but I don't want to do that. Is there a simpler way to change this binary format to a categorical variable?

       

      Thank you in advance. If my question did not make sense, please let me know. I will be happy to explain further. I have two work books. Book2 is what I want. Book 3 is what I have. Hope this makes sense...on a Friday at almost 5pm! Bad timing I'm sure.