You can do this using ifelse(). See example below. x<-rpois(100,100) NA.x<-sample(1:100,40) x[NA.x]=NA
y<-rpois(100,100) NA.y<-sample(1:100,40) y[NA.y]=NA z<-ifelse(!is.na(y),y,ifelse(!is.na(x),x,NA)) HTH, Daniel holly shakya wrote: > > I have 2 columns for weight. There are NAs in each column but not for the > same observation. Some observations have values for both. I would want to > prioritize the WT2 values so I would like to do the following: > >>From this: > ID WT1 WT2 > 1 134 NA > 2 145 155 > 1 NA 175 > 3 NA 187 > > To this: > ID WT1 WT2 WT > 1 NA 175 175 > 2 145 155 155 > 3 NA 187 187 > > Populating the NA values of wt2 with those of wt1 would work as well. Any > suggestions would be greatly appreciated. > -- > Holly Shakya > > Doctoral Student > San Diego State University/University of California, San Diego > Joint Doctoral Program in Public Health > (Global Health) > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > -- View this message in context: http://r.789695.n4.nabble.com/creating-a-new-column-with-values-from-another-tp3808528p3808550.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.