Create an n (where n is the number of different inhalers) x 2 (date a cumulative odsage) x 210 (max number of 30 day periods) array. When reading the first observation for a patient, zero out the array. For each observation, add the dosage to any entry for that inhaler that is less than 30 days old. Also start a new entry with this observations date. After processing the last observation for a patient, determine if any array entry exceeds the threshhold

________________________________________ From: SAS(r) Discussion [SAS-L@LISTSERV.UGA.EDU] On Behalf Of Joanne Mor [joanne2375@GMAIL.COM] Sent: Friday, August 20, 2010 11:37 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Fwd: Drug dosage exceed calculation

SAS-L gurus,

I am using a data set of health insurance claims for asthma inhalers (over a 7 month period) and need to determine who has exceed the max recommended dose for 30 days. Can someone steer me in the right direction on how to do this? I have all the relevant data including date of service, drug name, strength, quantity, days supply.

TIA!