Christopher David Desjardins
2009-Feb-03 23:15 UTC
[R] Problem recoding several variables into one
Hi, I am running the following code: ret <- data.frame(V1=rep(NA,dim(hhm)[1])) years <- c("grade04","grade05","grade06","grade07","grade08") for(i in 1:(length(years)-1)){ ret[,i] <- ifelse(hhm[,years[i+1]]==hhm[,years[i]],1,0)} ret$ret.s <- ifelse(ret$V1==1 | ret$V2==1 | ret$V3==1 | ret $V4==1,c("1"),c("0")) However, when it encounters an 'NA' in these variables it assigns ret.s an 'NA'. What I want it to do is either assign a 0 or a 1. A 1 should occur if an individual has the same value for grade04 & grade05, grade05 & grade06, and so on. If the individual does not have this I would like to assign a value of 0. However, when it encounters a NA it assigns an NA. How can I overcome this? Thanks, Chris