Hi, I have patient-level clinical trial data, and wish to apply a risk prediction model (Cox PH model) to calculate the group level hazard ratio comparing an intervention with a placebo. How do I do this?   E.g. Risk prediction model: HR =e^(a + b1x + b2x....) Need to apply to individual level data which compares the risk of events. Then generate group-level hazard ratio.   ... View more

Hi,    I have a list of patients and whether and when they filled a diabetes drug, had an hospitalization claim for diabetes, and/or had a outpatient diagnosis for diabetes (DiabetesOutcome=1). Having trouble with multiple dates.   ENROLID = person id   Drug: DMDrug = Diabetes drug (0= no diabetes drug, 1= filled diabetes drug) DMDrugDate1-DMDrugDate52 = all fill dates for diabetic drug   Hospital InptPrimDMDx = Primary hospital diagnosis for diabetes (0= Yes, 1= No) InptSecDMDx = Secondary hospital diagnosis for diabetes (0= Yes, 1= No) InptPrimDMDx_Date1 to InptPrimDMDx_Date9 = all dates of hospitalization with primary diagnosis of diabetes InptSecDMDx_Date1 to InptSecDMDx_Date4 =  all dates of hospitalization with secondary diagnosis of diabetes Doctor office visits OutptDMDx= Office visit with diabetes diagnosis (0= Yes, 1= No) OutptDMDate_1 to OutptDMDate_38 = all dates for office visit with diabetes diagnosis My decision rules for actual DiabetesOutcome1:  If InptPrimDMDx = 1 then DiabetesOutcome = 1 OR If DMDrug =1 AND If DMDrugDate within +/- 120 days of InptSecDMDx_Date OR within +/- 120 days off OutptDMDate then  DiabetesOutcome = 1; OR If InptSecDMDx =1  AND if InptSecDMDx_Date within +/- 120 days of DMDrugDate OR within +/- 120 days of OutptDMDate then  DiabetesOutcome = 1  OR If OutptDMDx=1 AND if OutptDMDate within +/- 120 days of DMDrugDate OR within +/- 120 days of InptSecDMDx then  DiabetesOutcome = 1  Then the first date that drug was filled, or inpatient/outpatient claim would be the date of DiabetesOutcome =1   Dataset looks somethin like this: ENROLID   InptPrimDx InptSecDMDx   InptSecDMDx InptSecDMDxDate1.... InptSecDMDxDate38    DMDrug    DMDrugDate1...52 1                         1             5/1/15                    1                  6/15/15     7/15/15                                                   1                  5/4/15 2                          0               .                           0                   Any help is greatly appreciated.   Thank you     .                                                                                     ... View more

Hi, New to SAS. Any help is greatly appreciated! I have a list of people on drug X with their first date of fill of drug X (fill_dt1) and 180 days after, where I transposed all their fill dates to see what date they were covered with drug from DAY1 to DAY180. Want to see if they filled drug X for at least two 14 days consecutively within the 60 day prior to INDEXDT. How would I do this? What I have: INDEXDT = Index date of person fill_dt1 = Date of First fill of drug X DAY1= Day of first fill (if 1= person on drug, if 0 then person not on drug) ID         INDEXDT         fill_dt1              DAY1   DAY2   DAY3   DAY4   DAY5   DAY6…..DAY180     1          02/13/2012         01/30/2013         1             1             1             1             1             0 2 3 4 Thanks! ... View more