Re: [R] Subsetting isolating a group of values in a group of variables

Hi Razi, Using dat1: dat1[apply(dat1[,2:4],1,function(x) any(x%in% vec1)),] #  ID diag1 diag2 diag3 proc1 proc2 proc3 #2  2   k69   i80  u456  z456  z123  z456 #3  3   l91  i801  g678  u456  u123  u123 #4  4   i80   i90  h983  z123  z456  z456 #similarly, if the columns are from 18:93, change ac

Re: [R] Subsetting isolating a group of values in a group of variables

Hi, Using the same example: str1<-paste(colnames(dat1)[grepl("diag",colnames(dat1))],"%in%","vec1",collapse="|")  subset(dat1,eval(parse(text=str1))) #  ID diag1 diag2 diag3 proc1 proc2 proc3 #2  2   k69   i80  u456  z456  z123  z456 #3  3   l91  i801  g678  u456  u123  u123 #4  4   i80   i90  h983

Re: [R] Subsetting isolating a group of values in a group of variables

Hi, The expected output is not clear. dat1<- read.table(text="ID diag1 diag2 diag3 proc1 proc2 proc3 1 k23 i269 j123   u123  u456  u123 2 k69 i80 u456   z456  z123  z456 3 l91 i801 g678   u456  u123  u123 4 i80 i90 h983   z123  z456   z456",sep="",header=TRUE,stringsAsFactors=FALSE) vec1<- c("i80