Frequencies for first 10,000 rows of route variable in drug2012q3 dataset : The route of drug | administration | Freq. Percent Cum. -----------------------------+----------------------------------- | 3,736 37.36 37.36 21060 | 1 0.01 37.37 21073 | 1 0.01 37.38 76273 | 1 0.01 37.39 CUTANEOUS | 1 0.01 37.40 DENTAL | 2 0.02 37.42 EPIDURAL | 5 0.05 37.47 INTRA-ARTERIAL | 1 0.01 37.48 INTRA-UTERINE | 28 0.28 37.76 INTRADERMAL | 1 0.01 37.77 INTRAMUSCULAR | 227 2.27 40.04 INTRAOCULAR | 2 0.02 40.06 INTRAPERITONEAL | 86 0.86 40.92 INTRATHECAL | 4 0.04 40.96 INTRAVENOUS | 889 8.89 49.85 INTRAVENOUS BOLUS | 9 0.09 49.94 INTRAVENOUS DRIP | 93 0.93 50.87 NASAL | 18 0.18 51.05 OPHTHALMIC | 17 0.17 51.22 ORAL | 3,326 33.26 84.48 OROPHARINGEAL | 1 0.01 84.49 OTHER | 15 0.15 84.64 PARENTERAL | 3 0.03 84.67 PERINEURAL | 2 0.02 84.69 RECTAL | 6 0.06 84.75 RESPIRATORY (INHALATION) | 83 0.83 85.58 SUBCUTANEOUS | 264 2.64 88.22 SUBLINGUAL | 5 0.05 88.27 TOPICAL | 29 0.29 88.56 TRANSDERMAL | 69 0.69 89.25 TRANSMAMMARY | 3 0.03 89.28 TRANSPLACENTAL | 39 0.39 89.67 UNKNOWN | 1,023 10.23 99.90 VAGINAL | 10 0.10 100.00 -----------------------------+----------------------------------- Total | 10,000 100.00 by Jean Roth , jroth@nber.org , 18 Dec 2015