Hello All,
I am trying to create algorithms to count Polypharmacy following the article:https://www.longdom.org/open-access/...52.1000151.pdf
from Electronic Health Data that looks like:
* Example generated by -dataex-. To install: ssc install dataex
clear
input byte id float fill_date str12 Drug byte Duration
1 21652 "Metformin" 30
1 21652 "Simvastatin" 30
1 21652 "Aspirin" 30
1 21652 "Amaryl" 60
1 21710 "Metformin" 30
1 21710 "Simvastatin" 30
1 21710 "Aspirin" 60
1 21740 "Metformin" 30
1 21740 "Amaryl" 30
1 21740 "Aspirin" 30
1 21771 "Metformin" 30
1 21771 "Amaryl" 30
1 21771 "Aspirin" 30
1 20708 "Metformin" 30
1 20708 "Amaryl" 30
1 21803 "Aspirin" 30
1 21803 "Simavastatin" 30
end
format %tdDD/NN/CCYY fill_date

First: I want to see for different patients if >= 5 drugs were used for >= 60 days in a year.
Second: I want to see for different patients if >= 5 drugs were used for >= 60 days per quarter.
Thank you in advance for help!