Chuck Cleland <[EMAIL PROTECTED]> writes: > > data <- as.data.frame(cbind(X1,X2,X3,X4,X5)) > > > > So only X1, X3 and X5 are vars without any NAs and there are some vars (X2 > > and > > X4 stacked in between that have NAs). Now, how can I extract those former > > vars > > in a new dataset or remove all those latter vars in between that have NAs > > (without missing a single row)? > > ... > > Someone else will probably suggest something more elegant, but how > about this: > > newdata <- data[,-which(apply(data, 2, function(x){all(is.na(x))}))]
(I think that's supposed to be any(), not all(), and which() is crossing the creek to fetch water.) This should do it: data[,apply(!is.na(data),2,all)] -- O__ ---- Peter Dalgaard Ă˜ster Farimagsgade 5, Entr.B c/ /'_ --- Dept. of Biostatistics PO Box 2099, 1014 Cph. K (*) \(*) -- University of Copenhagen Denmark Ph: (+45) 35327918 ~~~~~~~~~~ - ([EMAIL PROTECTED]) FAX: (+45) 35327907 ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html