Hi, May be this helps: dat <- read.table(text="day ID var Month 1 11 x March 1 11 x March 1 11 x April 1 11 y March 1 11 x March 1 11 y March 2 11 x March 2 11 y March 3 11 x March 3 11 y March 4 11 y March",sep="",header=TRUE,stringsAsFactors=FALSE)
indx <- with(dat,var=="y"& Month=="March"|var=="x" & Month!="March") dat1 <- dat[indx,] dat2 <- dat[!indx,] dat1$Month <- factor(dat1$Month,levels=month.name) dat1[with(dat1,order(day,ID,Month)),] A.K. On Tuesday, February 11, 2014 8:29 AM, Val <valkr...@gmail.com> wrote: Hi all, I have a sample of data set with variables day, ID,var and month: day ID var Month 1 11 x March 1 11 x March 1 11 x April 1 11 y March 1 11 x March 1 11 y March 2 11 x March 2 11 y March 3 11 x March 3 11 y March 4 11 y March In the above data set there are four unique days within ID. For example ID "11" has four records on day 1 and if this ID has "y" in "March" then I want keep "y" and discard "xs". Is it possible to keep them in two data sets ( wanted and unwanted) The output for wanted data set will be: 1 11 y March 1 11 x April 1 11 y March 2 11 y March 3 11 y March 4 11 y March thanks in advance [[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. ______________________________________________ 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.
