"
 HEDIS 2020 Medication List Directory 2020-03-06.xlsx
 Measures to Medication Lists
 Medication Lists to Codes
 Summary of Changes-Medications
 "
## [1] "\n HEDIS 2020 Medication List Directory 2020-03-06.xlsx\n Measures to Medication Lists\n Medication Lists to Codes\n Summary of Changes-Medications\n "
 library(printr)
## Registered S3 method overwritten by 'printr':
##   method                from     
##   knit_print.data.frame rmarkdown
 #library(rmarkdown)
 options(width=120)
 library(readxl)
 xl <- "C:/zz/data/xlsx/HEDIS 2020 Medication List Directory 2020-03-06.xlsx"

 df <- read_excel(xl ,sheet = "Summary of Changes-Medications")
## New names:
## * `` -> ...6
## * `` -> ...7
## * `` -> ...8
 summary(df)
Medication List Change Medication Name Description Date …6 …7 …8
Length:22 Length:22 Length:22 Length:22 Length:22 Mode:logical Mode:logical Mode:logical
Class :character Class :character Class :character Class :character Class :character NA’s:22 NA’s:22 NA’s:22
Mode :character Mode :character Mode :character Mode :character Mode :character NA NA NA 
 attach(df)
   (names(df))
## [1] "Medication List" "Change"          "Medication Name" "Description"     "Date"            "...6"           
## [7] "...7"            "...8"
 #] "Medication List" "Change"          "Medication Name" "Description"     "Date"            "...6"            "...7"            "...8"  
 head(table(df[1]))
ADHD Medications Antipsychotic Medications Benralizumab Medications Contraceptive Medications CWP Antibiotic Medications DMARD Medications
1 2 1 1 1 2 
 for (c in 2:ncol(df)-1) 
   print(head(table(df[c])))
## 
##           ADHD Medications  Antipsychotic Medications   Benralizumab Medications  Contraceptive Medications 
##                          1                          2                          1                          1 
## CWP Antibiotic Medications          DMARD Medications 
##                          1                          2 
## 
##   Added Deleted 
##      12      10 
## 
##               Amphetamine-dextroamphetamine                                 Baricitinib 
##                                           1                                           1 
##                                Benralizumab                   Buprenorphine (injection) 
##                                           1                                           1 
##                                  Calcitonin Ethinyl estradiol-folic acid-levonorgestrel 
##                                           1                                           1 
## 
##                                Anti-interleukin-5            Anticholinergic agents, antihistamines 
##                                                 1                                                 1 
##            Anticholinergic agents, antispasmodics Anticholinergics, first-generation antihistamines 
##                                                 1                                                 1 
##                                    Antispasmodics                                   Antithrombotics 
##                                                 1                                                 1 
## 
## 2019-07-01 2019-11-01 2020-03-06 
##         16          5          1 
## integer(0)
## integer(0)
 table(head(`Medication Name`))
Amphetamine-dextroamphetamine Benralizumab Ethinyl estradiol-folic acid-levonorgestrel Penicillin G Benthazine Prochlorperazine Quetiapine fumarate
1 1 1 1 1 1 
 table(head(`Description`))
Anti-interleukin-5 CNS Stimulants Contraceptives Miscellaneous antipsychotic agents Natural penicillins Phenothiazine antipsychotics
1 1 1 1 1 1 
 df <- read_excel(xl ,sheet = "Measures to Medication Lists")
 attach(df)
 summary(df)
Measure ID Measure Name Medication List Name Medication List OID
Length:459 Length:459 Length:459 Length:459
Class :character Class :character Class :character Class :character
Mode :character Mode :character Mode :character Mode :character 
 names(df)
## [1] "Measure ID"           "Measure Name"         "Medication List Name" "Medication List OID"
 # ] "Measure ID"           "Measure Name"         "Medication List Name" "Medication List OID" 
 head(table(df[1]))
AAB ABX ADD AMM AMR APM
1 2 1 1 21 3 
 for (c in 2:ncol(df)-1) 
   print(head(table(df[c])))
## 
## AAB ABX ADD AMM AMR APM 
##   1   2   1   1  21   3 
## 
## Adherence to Antipsychotic Medications for Individuals With Schizophrenia 
##                                                                        27 
##                                                    Antibiotic Utilization 
##                                                                         2 
##                                      Antidepressant Medication Management 
##                                                                         1 
##                         Appropriate Testing for Children With Pharyngitis 
##                                                                         1 
##       Appropriate Treatment for Children With Upper Respiratory Infection 
##                                                                         1 
##                                                   Asthma Medication Ratio 
##                                                                        21 
## 
##                                           5-ARI Medications                                  AAB Antibiotic Medications 
##                                                           1                                                           1 
##                           ACE Inhibitor and ARB Medications Acetaminophen Butalbital Caffeine Codeine 30 mg Medications 
##                                                           1                                                           1 
##       Acetaminophen Butalbital Caffeine Codeine Medications     Acetaminophen Caffeine Dihydrocodeine 16 mg Medications 
##                                                           2                                                           1
 table(`Medication List Name`)
5-ARI Medications AAB Antibiotic Medications ACE Inhibitor and ARB Medications Acetaminophen Butalbital Caffeine Codeine 30 mg Medications Acetaminophen Butalbital Caffeine Codeine Medications Acetaminophen Caffeine Dihydrocodeine 16 mg Medications Acetaminophen Caffeine Dihydrocodeine Medications Acetaminophen Codeine 15 mg Medications Acetaminophen Codeine 2.4 MGPML Medications Acetaminophen Codeine 30 mg Medications Acetaminophen Codeine 60 mg Medications Acetaminophen Codeine Medications Acetaminophen Hydrocodone .5 MGPML Medications Acetaminophen Hydrocodone .67 MGPML Medications Acetaminophen Hydrocodone 10 mg Medications Acetaminophen Hydrocodone 2.5 mg Medications Acetaminophen Hydrocodone 5 mg Medications Acetaminophen Hydrocodone 7.5 mg Medications Acetaminophen Hydrocodone Medications Acetaminophen Oxycodone 10 mg Medications Acetaminophen Oxycodone 2.5 mg Medications Acetaminophen Oxycodone 5 mg Medications Acetaminophen Oxycodone 7.5 mg Medications Acetaminophen Oxycodone Medications Acetaminophen Tramadol 37.5 mg Medications Acetaminophen Tramadol Medications ADHD Medications Albuterol Medications Alcohol Use Disorder Treatment Medications All Other Antibiotics by NCQA Drug Class Medications Amitriptyline Medications Amitriptyline Perphenazine Oral Medications Amlodipine Atorvastatin High Intensity Medications Amlodipine Atorvastatin Moderate Intensity Medications Amobarbital Medications Amoxapine Medications Antibiotics of Concern by NCQA Drug Class Medications Antidepressant Medications Antipsychotic Combination Medications Antipsychotic Medications Aripiprazole Oral Medications Asenapine Oral Medications Aspirin Butalbital Caffeine Codeine 30 mg Medications Aspirin Butalbital Caffeine Codeine Medications Aspirin Caffeine Dihydrocodeine 16 mg Medications Aspirin Caffeine Dihydrocodeine Medications Aspirin Carisoprodol Codeine 16 mg Medications Aspirin Carisoprodol Codeine Medications Aspirin Oxycodone 4.8355 mg Medications Aspirin Oxycodone Medications Asthma Exclusions Medications Atorvastatin High Intensity Medications Atorvastatin Moderate Intensity Medications Atropine Medications Beclomethasone Medications Belladonna Medications Belladonna Opium 30 mg Medications Belladonna Opium 60 mg Medications Belladonna Opium Medications Benralizumab Medications Benztropine Medications Beta-Blocker Medications Brexpiprazole Oral Medications Brompheniramine Medications Bronchodilator Medications Budesonide Formoterol Medications Budesonide Medications Buprenorphine Implant Medications Buprenorphine Injection Medications Buprenorphine Medications Buprenorphine Naloxone Medications Buprenorphine Oral Medications Butabarbital Medications Butalbital Medications Butorphanol 10 MGPML Medications Butorphanol Medications Carbinoxamine Medications Cariprazine Oral Medications Carisoprodol Medications Ciclesonide Medications Clemastine Medications Clomipramine Medications Clozapine Oral Medications Codeine Sulfate 15 mg Medications Codeine Sulfate 30 mg Medications Codeine Sulfate 60 mg Medications Codeine Sulfate Medications Conjugated Estrogens Medications Contraceptive Medications Corticosteroid Medications Cox-2 Selective NSAIDs and Nonaspirin NSAIDs Medications CWP Antibiotic Medications Cyclobenzaprine Medications Cyproheptadine Medications Chlordiazepoxide Clidinium Medications Chlorpromazine Oral Medications Chlorpropamide Medications Chlorpheniramine Medications Chlorzoxazone Medications Dementia Medications Desiccated Thyroid Medications Desipramine Medications Dexbrompheniramine Medications Dexchlorpheniramine Medications Diabetes Medications Dicyclomine Medications Digoxin .05 mg per mL Medications Digoxin .0625 mg Medications Digoxin .1 mg per mL Medications Digoxin .125 mg Medications Digoxin .1875 mg Medications Digoxin .25 mg Medications Digoxin .25 mg per mL Medications Dimenhydrinate Medications Dipyridamole Medications Diphenhydramine Medications Disopyramide Medications DMARD Medications Doxepin 10 mg Medications Doxepin 10 mg per mL Medications Doxepin 100 mg Medications Doxepin 150 mg Medications Doxepin 25 mg Medications Doxepin 3 mg Medications Doxepin 50 mg Medications Doxepin 6 mg Medications Doxepin 75 mg Medications Doxylamine Medications Dyphylline Guaifenesin Medications Ergoloid Mesylates Medications Esterified Estrogens Medications Estradiol Medications Estrogen Agonists Medications Estropipate Medications Ezetimibe Simvastatin High Intensity Medications Ezetimibe Simvastatin Low Intensity Medications Ezetimibe Simvastatin Moderate Intensity Medications Fentanyl 100 mcg Medications Fentanyl 100 MCGPS Nasal Medications Fentanyl 100 MCGPS Oral Medications Fentanyl 100 MCGPH Medications Fentanyl 12 MCGPH Medications Fentanyl 1200 mcg Medications Fentanyl 1600 mcg Medications Fentanyl 200 mcg Medications Fentanyl 200 MCGPS Oral Medications Fentanyl 25 MCGPH Medications Fentanyl 300 mcg Medications Fentanyl 300 MCGPS Nasal Medications Fentanyl 37.5 MCGPH Medications Fentanyl 400 mcg Medications Fentanyl 400 MCGPS Nasal Medications Fentanyl 400 MCGPS Oral Medications Fentanyl 50 MCGPH Medications Fentanyl 600 mcg Medications Fentanyl 600 MCGPS Oral Medications Fentanyl 62.5 MCGPH Medications Fentanyl 75 MCGPH Medications Fentanyl 800 mcg Medications Fentanyl 800 MCGPS Oral Medications Fentanyl 87.5 MCGPH Medications Fentanyl Medications Flunisolide Medications Fluphenazine Oral Medications Fluticasone Medications Fluticasone Salmeterol Medications Fluticasone Vilanterol Medications Fluvastatin Low Intensity Medications Fluvastatin Moderate Intensity Medications Formoterol Mometasone Medications Glimepiride Medications Glyburide Medications Guanfacine Medications Haloperidol Oral Medications High Risk Anti Infectives Medications Hydrocodone 10 mg Medications Hydrocodone 100 mg Medications Hydrocodone 120 mg Medications Hydrocodone 15 mg Medications Hydrocodone 20 mg Medications Hydrocodone 30 mg Medications Hydrocodone 40 mg Medications Hydrocodone 50 mg Medications Hydrocodone 60 mg Medications Hydrocodone 80 mg Medications Hydrocodone Ibuprofen 10 mg Medications Hydrocodone Ibuprofen 2.5 mg Medications Hydrocodone Ibuprofen 5 mg Medications Hydrocodone Ibuprofen 7.5 mg Medications Hydrocodone Ibuprofen Medications Hydrocodone Medications Hydromorphone 1 MGPML Medications Hydromorphone 12 mg Medications Hydromorphone 16 mg Medications Hydromorphone 2 mg Medications Hydromorphone 3 mg Medications Hydromorphone 32 mg Medications Hydromorphone 4 mg Medications Hydromorphone 8 mg Medications Hydromorphone Medications Hydroxyzine Medications Hyoscyamine Medications Ibuprofen Oxycodone 5 mg Medications Ibuprofen Oxycodone Medications Iloperidone Oral Medications Imipramine Medications Indomethacin Medications Isoxsuprine Medications Ketorolac Medications Levalbuterol Medications Levorphanol 1 mg Medications Levorphanol 2 mg Medications Levorphanol 3 mg Medications Levorphanol Medications Long Acting Injections 14 Days Supply Medications Long Acting Injections 28 Days Supply Medications Long Acting Injections 30 Days Supply Medications Lovastatin Low Intensity Medications Lovastatin Moderate Intensity Medications Loxapine Oral Medications Lurisadone Oral Medications Meclizine Medications Megestrol Medications Meperidine 10 MGPML Medications Meperidine 100 mg Medications Meperidine 50 mg Medications Meperidine Combinations Medications Meperidine Medications Meperidine Promethazine 50 mg Medications Meperidine Promethazine Medications Mepolizumab Medications Meprobamate Medications Metaxalone Medications Methadone 1 MGPML Medications Methadone 10 mg Medications Methadone 10 MGPML Medications Methadone 2 MGPML Medications Methadone 40 mg Medications Methadone 5 mg Medications Methadone Medications Methocarbamol Medications Methscopolamine Medications Methyldopa Medications Molindone Oral Medications Mometasone Medications Montelukast Medications Morphine .4 MGPML Medications Morphine 10 mg Medications Morphine 100 mg Medications Morphine 120 mg Medications Morphine 130 mg Medications Morphine 15 mg Medications Morphine 150 mg Medications Morphine 2 MGPML Medications Morphine 20 mg Medications Morphine 20 MGPML Medications Morphine 200 mg Medications Morphine 30 mg Medications Morphine 4 MGPML Medications Morphine 40 mg Medications Morphine 45 mg Medications Morphine 5 mg Medications Morphine 50 mg Medications Morphine 60 mg Medications Morphine 70 mg Medications Morphine 75 mg Medications Morphine 80 mg Medications Morphine 90 mg Medications Morphine Medications Morphine Naltrexone 100 mg Medications Morphine Naltrexone 20 mg Medications Morphine Naltrexone 30 mg Medications Morphine Naltrexone 50 mg Medications Morphine Naltrexone 60 mg Medications Morphine Naltrexone 80 mg Medications Morphine Naltrexone Medications Naloxone Pentazocine 50 mg Medications Naloxone Pentazocine Medications Naltrexone Injection Medications Naltrexone Oral Medications Nifedipine Medications Nonbenzodiazepine Hypnotics Medications Nortriptyline Medications Olanzapine Oral Medications Omalizumab Medications Opioid Use Disorder Treatment Medications Opium Medications Orphenadrine Medications Osteoporosis Medications Oxycodone 1 MGPML Medications Oxycodone 10 mg Medications Oxycodone 13.5 mg Medications Oxycodone 15 mg Medications Oxycodone 18 mg Medications Oxycodone 20 mg Medications Oxycodone 20 MGPML Medications Oxycodone 27 mg Medications Oxycodone 30 mg Medications Oxycodone 36 mg Medications Oxycodone 40 mg Medications Oxycodone 5 mg Medications Oxycodone 60 mg Medications Oxycodone 7.5 mg Medications Oxycodone 80 mg Medications Oxycodone 9 mg Medications Oxycodone Medications Oxymorphone 10 mg Medications Oxymorphone 15 mg Medications Oxymorphone 20 mg Medications Oxymorphone 30 mg Medications Oxymorphone 40 mg Medications Oxymorphone 5 mg Medications Oxymorphone 7.5 mg Medications Oxymorphone Medications Paliperidone Oral Medications Paroxetine Medications Pentobarbital Medications Perphenazine Oral Medications Pitavastatin Low Intensity Medications Pitavastatin Moderate Intensity Medications Potentially Harmful Drugs - Dementia Medications Potentially Harmful Drugs - History of Falls and Dementia Medications Potentially Harmful Drugs - History of Falls Medications Pravastatin Low Intensity Medications Pravastatin Moderate Intensity Medications Prochlorperazine Medications Prochlorperazine Oral Medications Promethazine Medications Propantheline Medications Protriptyline Medications Pyrilamine Medications Phenobarbital Medications Quetiapine Oral Medications Reserpine 0.1 mg Medications Reserpine 0.25 mg Medications Reslizumab Medications Retinoid Medications Risperidone Oral Medications Rosuvastatin High Intensity Medications Rosuvastatin Moderate Intensity Medications Scopolamine Medications Secobarbital Medications Simvastatin High Intensity Medications Simvastatin Low Intensity Medications Simvastatin Moderate Intensity Medications SSD Antipsychotic Medications Systemic Corticosteroid Medications Tapentadol 100 mg Medications Tapentadol 150 mg Medications Tapentadol 200 mg Medications Tapentadol 250 mg Medications Tapentadol 50 mg Medications Tapentadol 75 mg Medications Tapentadol Medications Theophylline Medications Thioridazine Oral Medications Thiothixene Oral Medications Tramadol 100 mg Medications Tramadol 150 mg Medications Tramadol 200 mg Medications Tramadol 300 mg Medications Tramadol 50 mg Medications Tramadol Medications Trifluoperazine Oral Medications Trihexyphenidyl Medications Trimipramine Medications Triprolidine Medications Zafirlukast Medications Zileuton Medications Ziprasidone Oral Medications
1 1 1 1 2 1 2 1 1 1 1 2 1 1 1 1 1 1 2 1 1 1 1 2 1 2 1 2 3 1 1 1 2 2 1 1 1 3 2 2 1 1 1 2 1 2 1 2 1 2 1 2 2 1 2 1 1 1 2 2 1 1 1 1 1 2 2 1 1 2 1 1 1 1 1 2 1 1 1 2 1 1 1 1 1 1 2 1 1 1 1 2 1 1 1 1 1 1 1 11 1 1 1 1 4 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 2 1 2 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 1 2 2 2 1 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 1 1 1 1 1 1 1 1 2 1 1 1 2 1 1 1 1 1 2 1 1 1 2 1 1 1 1 2 1 1 1 1 1 1 1 1 2 1 2 2 1 1 1 1 1 1 1 1 2 1 1 1 1 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 2 1 2 1 1 1 1 1 1 2 3 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 2 1 1 1 1 1 2 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 2 1 1 2 2 1 1 2 1 2 1 1 1 1 1 1 1 1 2 2 1 1 1 1 1 1 1 2 1 1 1 1 2 2 1 
 table(`Measure ID`)
AAB ABX ADD AMM AMR APM APP ART BCS CBP CDC COL COU CWP CHL DAE DDE FUI HDO IAD IET LBP MMA OMW PBH PCE PDS PND POD PSA SAA SMD SPC SPD SSD UOP URI
1 2 1 1 21 3 2 2 1 1 3 1 31 1 2 86 5 2 150 2 2 1 21 2 3 2 1 1 6 1 27 1 16 23 2 31 1 
 table(`Measure Name`)
Adherence to Antipsychotic Medications for Individuals With Schizophrenia Antibiotic Utilization Antidepressant Medication Management Appropriate Testing for Children With Pharyngitis Appropriate Treatment for Children With Upper Respiratory Infection Asthma Medication Ratio Avoidance of Antibiotic Treatment in Adults With Acute Bronchitis Breast Cancer Screening Colorectal Cancer Screening Comprehensive Diabetes Care Controlling High Blood Pressure Chlamydia Screening in Women Diabetes Monitoring for People With Diabetes and Schizophrenia Diabetes Screening for People With Schizophrenic or Bipolar Disorder Who Are Using Antipsychotic Medications Disease-Modifying Anti-Rheumatic Drug Therapy for Rheumatoid Arthritis Follow-Up After High-Intensity Care for Substance Use Disorder Follow-Up Care for Children Prescribed ADHD Medication Identification of Alcohol and Other Drug Services Initiation and Engagement of Alcohol and Other Drug Abuse or Dependence Treatment Medication Management for People With Asthma Metabolic Monitoring for Children and Adolescents on Antipsychotics Non-Recommended PSA-Based Screening in Older Men Osteoporosis Management in Women Persistence of Beta-Blocker Treatment After a Heart Attack Postpartum Depression Screening and Follow-Up Potentially Harmful Drug-Disease Interactions in the Elderly Prenatal Depression Screening and Follow-Up Pharmacotherapy for Opioid Use Disorder Pharmacotherapy Management of COPD Exacerbation Risk of Continued Opioid Use Statin Therapy for Patients With Cardiovascular Disease Statin Therapy for patients With Diabetes Use of First-Line Psychosocial Care for Children and Adolescents on Antipsychotics Use of High-Risk Medications in the Elderly Use of Imaging Studies for Low Back Pain Use of Opioids at High Dosage Use of Opioids From Multiple Providers
27 2 1 1 1 21 1 1 1 3 1 2 1 2 2 2 1 2 2 21 3 1 2 3 1 5 1 6 2 31 16 23 2 86 1 150 31 
 #table(df[4])