Hi All . I ma trying to find the total number of patient who are on dual or triple drugs on the same time. Here is my data patient id rx_date drug name Rx_end_date
1 3/1/2003 a 3/31/2003
1 3/28//2003 b 4/28/2003
1 2/1/2003 c 7/4/2008
1 4/4/2005 a 5/4/2005
2 1/1/2004 a 2/1/2004
2 1/12/2004 b 2/12/2004
2 2/2/2009 a 3/2/2009
2 2/5/2009 b 3/5/2009
3 1/1/2004 d 2/1/2004
3 6/6/2004 d 8/6/2004
3 6/12/2004 b 7/12/2004
3 6/29/2004 a 7/29/2004
I want the following output considering that the deifnition of dual, triple, or more therapy are those with an rx_Date that occur within 30 days of the other therapy.
% of monotherapy, % of dual, % of truple, % of 3 or more
... View more