Thank you very much Jim! It is working fine!! On Sun, Feb 28, 2016 at 1:46 AM, Jim Lemon <drjimle...@gmail.com> wrote: > Hi Ashta, > This does not seem too difficult: > > DF$flag<-"n" > for(thisname in unique(DF$Name)) { > if(any(DF$year[DF$Name == thisname] %in% c(2014,2015) & > DF$tag[DF$Name == thisname])) > DF$flag[DF$Name == thisname]<-"y" > } > > Jim > > On Sun, Feb 28, 2016 at 1:23 PM, Ashta <sewa...@gmail.com> wrote: >> Hi all, >> >> I have a data set represented by the following sample. >> >> I want flag records of an individual as "N", if if the tag column of >> an individual is equal to zero for the last two years. So in the >> following example, Alex1 records are flagged as "y", On the other >> hand Carla's records are flagged as "N" because all values of tag for >> Carla are zero. Another typical example is that Jon, although the tag >> values of Jon are greater than 0 it is flagged as "N", because his >> record are more than two years old. >> >> DF <- read.table(textConnection(" Name year tag >> Alex1 2011 0 >> Alex1 2012 1 >> Alex1 2013 0 >> Alex1 2014 1 >> >> Carla 2013 0 >> Carla 2014 0 >> Carla 2015 0 >> Carla 2012 0 >> >> Tom 2014 1 >> Tom 2015 1 >> >> Jon 2010 1 >> Jon 2011 1 "),header = TRUE) >> >> I want create another variable " Flag with value Y or N" if an >> individual has a value greater than 0 in the tag column for the last >> two years then the flag value will be y otherwise it n. >> >> >> the outcome will be >> name year tag Flag >> Alex1 2011 0 y >> Alex1 2012 1 y >> Alex1 2013 0 y >> Alex1 2014 1 y >> >> Carla 2013 0 n >> Carla 2014 0 n >> Carla 2015 0 n >> Carla 2012 0 n >> >> Tom 2014 1 y >> Tom 2015 1 y >> >> Jon 2010 1 n >> Jon 2011 1 n >> >> Thank you in advance >> >> ______________________________________________ >> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see >> 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 -- To UNSUBSCRIBE and more, see 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.