Dear all,
Currently I am working on medication database and trying to calculate of proportion of days covered (PDC; used in analyses of adherence).
I have never used STATA before so I am facing problem in every step of my analysis. Data looks as below:
input byte(id aspirin clopidogrel heparin lipid_lowering fibrate) str6(supply_date precsription_date)
1 1 0 0 0 0 "Apr-02" "Jan-02"
1 1 0 0 0 0 "Apr-02" "Jan-02"
1 1 0 1 0 0 "Apr-02" "Jan-02"
1 1 0 0 0 0 "Apr-02" "Jan-02"
2 1 1 0 0 0 "Feb-03" "Dec-02"
2 0 1 0 0 0 "Feb-03" "Dec-02"
2 0 1 0 1 0 "Mar-03" "Jan-03"
3 0 0 0 0 1 "Jan-10" "Nov-09"
3 1 0 0 0 0 "Jan-10" "Nov-09"
3 1 1 0 0 0 "Nov-10" "Sep-10"
3 1 1 0 0 0 "Nov-10" "Sep-10"
3 0 0 0 1 0 "Feb-10" "Feb-10"
4 0 0 0 0 1 "Jun-09" "Apr-09"
4 0 0 0 0 1 "Jun-09" "May-09"
5 0 1 0 0 0 "May-03" "May-03"
5 0 1 0 0 1 "May-03" "May-03"
5 0 1 0 1 0 "Aug-04" "Jun-10"
end
I am also sharing an article describing the calculation of proportion of days covered (PDC) that might be useful (but codes are in SAS).
http://www.ncpanet.org/pdf/adherence_list.pdf
According to this article following 4 steps are needed:
Step 1: Determine the patient’s measurement period, defined as the index prescription date to the end of the calendar year, disenrollment, or death.
Step 2 Within the measurement period, count the days the patient was covered by at least one drug in the class based on the prescription fill date and days of supply. If prescriptions for the same drug (GCN) overlap, then adjust the prescription start date to be the day after the previous fill has ended.
Step 3 Divide the number of covered days found in Step 2 by the number of days found in Step 1. Multiply this number by 100 to obtain the PDC (as a percentage) for each patient.
Step 4 Count the number of patients who had a PDC greater than 80% and then divide by the total number of eligible patients.
Any help will be greatly appreciated.
Thank you so much.
Kind regards,
Oyun
Currently I am working on medication database and trying to calculate of proportion of days covered (PDC; used in analyses of adherence).
I have never used STATA before so I am facing problem in every step of my analysis. Data looks as below:
input byte(id aspirin clopidogrel heparin lipid_lowering fibrate) str6(supply_date precsription_date)
1 1 0 0 0 0 "Apr-02" "Jan-02"
1 1 0 0 0 0 "Apr-02" "Jan-02"
1 1 0 1 0 0 "Apr-02" "Jan-02"
1 1 0 0 0 0 "Apr-02" "Jan-02"
2 1 1 0 0 0 "Feb-03" "Dec-02"
2 0 1 0 0 0 "Feb-03" "Dec-02"
2 0 1 0 1 0 "Mar-03" "Jan-03"
3 0 0 0 0 1 "Jan-10" "Nov-09"
3 1 0 0 0 0 "Jan-10" "Nov-09"
3 1 1 0 0 0 "Nov-10" "Sep-10"
3 1 1 0 0 0 "Nov-10" "Sep-10"
3 0 0 0 1 0 "Feb-10" "Feb-10"
4 0 0 0 0 1 "Jun-09" "Apr-09"
4 0 0 0 0 1 "Jun-09" "May-09"
5 0 1 0 0 0 "May-03" "May-03"
5 0 1 0 0 1 "May-03" "May-03"
5 0 1 0 1 0 "Aug-04" "Jun-10"
end
I am also sharing an article describing the calculation of proportion of days covered (PDC) that might be useful (but codes are in SAS).
http://www.ncpanet.org/pdf/adherence_list.pdf
According to this article following 4 steps are needed:
Step 1: Determine the patient’s measurement period, defined as the index prescription date to the end of the calendar year, disenrollment, or death.
Step 2 Within the measurement period, count the days the patient was covered by at least one drug in the class based on the prescription fill date and days of supply. If prescriptions for the same drug (GCN) overlap, then adjust the prescription start date to be the day after the previous fill has ended.
Step 3 Divide the number of covered days found in Step 2 by the number of days found in Step 1. Multiply this number by 100 to obtain the PDC (as a percentage) for each patient.
Step 4 Count the number of patients who had a PDC greater than 80% and then divide by the total number of eligible patients.
Any help will be greatly appreciated.
Thank you so much.
Kind regards,
Oyun
Comment