Hi Raghu,
Using the example you provided. If you want Q3 for year 2011 and 2013.
dat[grep("2011 Q3|2013 Q3", Qtr1),] #change accordingly
# ID Phase RESEARCH Area Date Result
#1 100 IV S_Care A&P 7/23/2013 Positive
#5 2005 IV Speci TH 8/4/2011
#6 2006 III Speci
Hi,
Please Check ?as.yearqtr() fromlibrary(zoo)
dat <- read.table(text="ID Phase RESEARCH Area Date Result
100 IV S_Care A&P 7/23/2013 Positive
1001 IV P_Care EU 12/20/2012 Positive
2001 IV Car AS 9/13/2012 Positive
20003 III Spec IN 10/6/2011
2 matches
Mail list logo