[R] (no subject)

[arun]

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 <valkremk at 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 at 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.