Dear R users,

I have a reproducible data and try to create new variable "clo" is 1  if
know variable is equal to "very well" or "fairly well" and getalong is 4 or
5
otherwise it is 0.

rep_data<- read.table(header=TRUE, text="
           id1        id2        know getalong
   100000016_a1 100000016_a2   very well        4
   100000035_a1 100000035_a2 fairly well       NA
   100000036_a1 100000036_a2   very well        3
   100000039_a1 100000039_a2   very well        5
   100000067_a1 100000067_a2   very well        5
   100000076_a1 100000076_a2 fairly well        5
")


rep_data$clo<- ifelse((rep_data$know==c("fairly well","very well") &
rep_data$getalong==c(4,5)),1,0)

For sure, something must be wrong, I couldn't find it out.

rep_data

                      id1    id2 know getalong clo
100000016_a1 100000016_a2   very well        4   0
100000035_a1 100000035_a2 fairly well       NA   0
100000036_a1 100000036_a2   very well        3   0
100000039_a1 100000039_a2   very well        5   0
100000067_a1 100000067_a2   very well        5   0
100000076_a1 100000076_a2 fairly well        5   0

Any help is appreciated..
Bests,
Niklas

	[[alternative HTML version deleted]]

