How to Create a Complex Conditional Variable on R

Question

I have four binary yes/no variables. I want to create a combined variable that is dummy coded in the following manner:

0 if participants say "Yes" to all 4 Variables (4/4)
1 if participants say "Yes" to 3 out of the 4 Variables (3/4)
2 if participants say "Yes to 2 out of the 4 Variables (2/4)
3 if participants say "Yes" to 1 out of the 4 Variables (1/4)
4 if participants say "Yes" to 0 out of the 4 Variables (0/4)

The order of which questions they've said yes to does not matter.

I've tried to create something like this:

VariableCodingFor1/4 <- ifelse(Var1 =="Yes" & Var2 == "No" & Var3 =="No", Var4 =="No") |
ifelse(Var1 =="No" & Var2 == "Yes" & Var3 =="No", Var4 =="No") |
ifelse(Var1 =="No" & Var2 == "No" & Var3 =="Yes", Var4 =="No") |
ifelse(Var1 =="No" & Var2 == "No" & Var3 =="No", Var4 =="Yes")

But I'm definitely missing something

Any help would be greatly appreciated !

Weöcome to SO. Please provide: stackoverflow.com/help/minimal-reproducible-example — deschen
– deschen, Commented Feb 28, 2022 at 8:04
It's easier to help you if you include a simple reproducible example with sample input and desired output that can be used to test and verify possible solutions. — MrFlick
– MrFlick, Commented Feb 28, 2022 at 8:07
Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. — Community
– Community Bot, Commented Feb 28, 2022 at 9:16

user2974951 · Accepted Answer · 2022-02-28 08:12:03Z

1

This?

> set.seed(123)
> df=data.frame(matrix(sample(c("Yes","No"),24,T),6,4))
> rowSums(df=="Yes")
[1] 2 3 3 2 2 2
> 4-rowSums(df=="Yes")
[1] 2 1 1 2 2 2

answered Feb 28, 2022 at 8:12

user2974951

10.4k2 gold badges21 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Create a Complex Conditional Variable on R

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related