Date:         Wed, 2 Feb 2011 12:12:03 -0800
Reply-To:     Nancy Li <nancy_li66@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nancy Li <nancy_li66@YAHOO.COM>
Subject:      Help for Coding problem
Content-Type: text/plain; charset=iso-8859-1

Hi dear SAS-Lers,
 
I have encountered a coding problem and would like to know whether anyone on the list could help me. 
 
My goal is to find patients who are concurrently taking 3 or more medications(different drug names) over a 6 month time period in 2010.  I need to look at the fill date along with the days supply to determine if there is any overlap between at least 3 different med scripts in a continuous 6 month period for a given patient. The following is the example data, any help would be highly appreciated!
 
Mem_id      Fill_date            Drug Name                             Days_supply
1B         15FEB2010       GLYBURIDE-METFORMIN HCL            90
1B         17MAY2010      GLYBURIDE-METFORMIN HCL            90
1B         17JUN2010        ACTOPLUS MET                                90
1B         17JUN2010       JANUMET                                           90
1B          07JUL2010       ACTOPLUS MET                                90
1B         02NOV2010      GLYBURIDE-METFORMIN HCL            90
2B         17JUN2010       JANUMET                                           90
2B          07JUL2010       ACTOPLUS MET                                90
2B         02NOV2010      GLYBURIDE-METFORMIN HCL            90
3B         15FEB2010       GLYBURIDE-METFORMIN HCL            90
3B         17MAY2010      GLYBURIDE-METFORMIN HCL            90
3B         17JUN2010        ACTOPLUS MET                                90
 
Thanks!
Nancy