Combining Indicator Columns

mcstagger

Hello all!

I have created what I believe are referred to as indicator columns. In my study I have two red herring questions to see if respondents are paying attention, not my idea, and I am trying to create a single variable containing...

1. Those who answered both correctly
2. Those who answered ONE wrong
3. Those who answered BOTH wrong

So we have a mutually exclusive set of groups. When I filtered I flagged TRUE with "1" and FALSE with nothing. I did this with all three groups which has left me with 3 columns that mirror the below excluding the last column...

BothCorrect	OneWrong	TwoWrong	What I want
.	2	.	2
1	.	.	1
.	.	3	3

What I am trying to do is combine the first 3 columns into the last at which point I would go in and label what 1, 2 and 3 are.

I tried a formula...

If(:BothCorrect == 1, 1, If(:OneWrong == 2, 2, If(:TwoWrong == 3, 3, "NA")))

That did not work, likely due to syntax.

Could anyone provide some guidance on this, please, with or without the use of a formula?

michael_jmp

If you have numeric columns and you're just looking for the first non missing value (or if you can assume that only one of the three columns will be non missing), this column formula might do want you need:

If( !Is Missing( :BothCorrect ),

    :BothCorrect,

    If( !Is Missing( :OneWrong ),

        :OneWrong,

        If( !Is Missing( :TwoWrong ),

            :TwoWrong,

            .

        )

    )

)