Hi All,

We are studying patients who are receiving suboxone and if they are receiving any of the following drug therapeutic classes:

Opioids and combinations; Barbiturates; Sedative-hypnotics; Anti-anxiety but only if they have a DEA code of 2, 3, 4, or 5; Butalbital combinations; Anticonvulsants but only if they have a DEA code of 2, 3, 4, or 5; Skeletal muscle relaxants; Stimulants; Any other prescription that is DEA code 2, 3, 4, or 5 that is not listed above.

Suboxone is defined as having one of the following GDC codes: 18973, 18974, 28958, 28959, 64673 and 64672.

The investigator wants to know specifically how many patients have each combination; each patient is to be counted only once.

Fox example, how many patients have only suboxone with none of the concurrent medications? How many patients have suboxone with just one of the concurrent medications?

Suboxone/Subutex and Opiods = X Suboxone/subutex and Barbiturates = X2 etc.

Then, how many patients have suboxone/subutex with two concurrent medications? Each of these tiers would be mutually exclusive so that the numbers add up.

Can anyone offer some suggestions on how to create such a report?

Code: DATA PHARM ;

INPUT ID GDC $ FILL_DATE :MMDDYY10. THER_CLASS $ DEA_CODE $;

FORMAT FILL_DATE MMDDYY10. ;

SS_RX = 0 ; OPIOIDS = 0; BARBITURATES = 0; SED_HYPNOTICS = 0; ANTI_ANX = 0; BUTALBITAL = 0; ANTI_CONV = 0; SKEL_RELX = 0; STIMULANTS = 0; OTHER=0;

IF GDC IN ('18973', '18974', '28958', '28959', '28959', '64672', '64673') THEN SS_RX = 1 ; ELSE IF GDC NOT IN ('18973', '18974', '28958', '28959', '28959', '64672', '64673') AND UPCASE(THER_CLASS) IN ('H3A', 'H3N', 'H3R', 'H3U', 'H3X') THEN OPIOIDS = 1; ELSE IF UPCASE(THER_CLASS) = 'H2D' THEN BARBITURATES = 1; ELSE IF UPCASE(THER_CLASS) = 'H2E' THEN SED_HYPNOTICS = 1; ELSE IF UPCASE(THER_CLASS) = 'H2F' AND DEA_CODE IN ('2', '3', '4', '5') THEN ANTI_ANX = 1; ELSE IF UPCASE(THER_CLASS) IN ('H3K', 'H3L', 'H3M', 'H3O') THEN BUTALBITAL = 1; ELSE IF UPCASE(THER_CLASS) = 'H4B' AND DEA_CODE IN ('2', '3', '4', '5') THEN ANTI_CONV = 1; ELSE IF UPCASE(THER_CLASS) = 'H6H' THEN SKEL_RELX = 1; ELSE IF UPCASE(THER_CLASS) IN ('H2V', 'J5B') THEN STIMULANTS = 1; ELSE IF DEA_CODE IN ('2', '3', '4', '5') THEN OTHER=1;

CARDS; 1 18973 10/2/2011 H3A 3 /* SUBOXONE ONLY */ 1 18973 11/2/2011 H3A 3 1 18974 12/2/2011 H3A 3 1 18973 01/2/2012 H3A 3 2 28959 03/24/2011 H3A 3 SUBOXONE AND BARBITURATES 2 43 05/12/2011 H2D 2 3 28959 02/24/2011 H3A 3 SUBOXONE AND BUTALBITAL AND STIMULANTS 3 55 04/24/2011 H3K 3 3 55 05/24/2011 H3K 3 3 55 06/14/2011 H2V 3 ; RUN;

The report would show that there was one patient taking only suboxone, one patient taking suboxone and barbiturates and one patient taking suboxone, butalbital and stimulants. I know this is a very simplistic example but I would hope you have an idea of what I need.

Thanks in advance for any help you can provide. Dave