生效日期:
code<-c("ABC")
DT<-data.table::data.table(
ID = c(1L, 1L, 1L, 1L, 1L),
INDX_DATE = c("2010-10-10","2010-10-11","2010-10-12",
"2010-10-13","2010-10-13"),
ATC = c("ABC123", "ABC12", "ABC", "DEF", NA),
ATC_DATE = c("2005-05-05","2011-11-11","2012-12-12",
"2011-11-11","2005-05-05")
)
请注意,情况并非如此.
ID INDX_DATE ATC ATC_DATE NR
1: 1 2010-10-10 ABC123 2005-05-05 2
2: 1 2010-10-11 ABC12 2011-11-11 2
3: 1 2010-10-12 ABC 2012-12-12 2
4: 1 2010-10-13 DEF 2011-11-11 2
5: 1 2010-10-13 <NA> 2005-05-05 2
逻辑:
我想计算ATC
以code
中定义的值开始的事件的nr,以及ATC_DATE > INDX_DATE
开始的事件的nr.NR
中汇总了每ID
个事件(唯一日期)的总数.
最好是快速(data.table)解决方案,因为我的数据集很大.
♪H♪