computer tools icon

Tools

Overview

This page contains a collection of software tools, primarily code or curated datasets, that has come out of my research program and which I think may be useful to other researchers.

If you discover errors, please bring them to my attention via email (ssmith@cop.ufl.edu).

RxNorm

We are curating lists of drugs for common chronic diseases from RxNorm, which can be found below.

drug class description
antiHYPERTENSIVESget app SAS datasets containing curated lists of antihypertensive RXCUIs and NDCs. RXCUIs includes only term types (TTY) allowable in the PCORnet common data modellaunch; also mapped are drug names and classes, both individually, and for combination products, a fixed-dose combination indicator, and the number of antihypertensive drugs associated with each RXCUI.

NDC lists are derived from the RXCUI lists, and thus are conditional on the above criteria for selecting RXCUIs; in addition, only 11-digit NDCs are included, as per PCORnet CDM specification
antiDIABETICSget app SAS datasets containing curated lists of antidiabetic RXCUIs and NDCs. RXCUIs includes only term types (TTY) allowable in the PCORnet common data modellaunch; also mapped are drug names and classes, both individually, and for combination products, a fixed-dose combination indicator, and the number of antidiabetic drugs associated with each RXCUI.

NDC lists are derived from the RXCUI lists, and thus are conditional on the above criteria for selecting RXCUIs; in addition, only 11-digit NDCs are included, as per PCORnet CDM specification.

Special thanks to my PharmD student, Nicole Donato, for help with curating these lists.

Multum Lexicon Drug Codes

Many publicly-available datasets in the U.S. (e.g., NHANES, NAMCS, MEPS, etc..) code drugs using the proprietary Multum Lexicon database produced by Cerner. The CDC provides a web-based tool for searching drug codeslaunch, but it is not particularly efficient for creating longer lists of drugs. Fortunately, RxNorm incorporates these codes and the RXNCONSO file can be queried relatively easily for a list of generic drugs. Here is SAS code we developed for that purpose, as well as example SAS datasets for antihypertensive drugs.

program description
Multum drug codesget app SAS program and accompanying example datasets (for antihypertensives) to extract Multum Lexicon drug codes (d#####) from publicly-available RxNorm fileslaunch.

Medication Reference Terminology (MED-RT)

MED-RT is produced by the U.S. Veterans Health Affairs and replaces the now-deprecated National Drug Formulary-Reference Terminology (NDFRT). The tool below includes a SAS program and XML map to convert MEDRT from the source XML file to SAS datasets.

program description
MEDRT-to-SASget app SAS program and accompanying XML mapping file to extract MEDRT terms, concepts, and associations from the source XML files produced as part of the Federated Medication Terminologieslaunch. The program creates 6 datasets (terms, concepts, concept properties, concept synonyms, associations and association qualifiers).

NPPES National Provider Indicator (NPI)

The Centers for Medicare and Medicaid Services (CMS)launch publishes monthly files including information on all U.S. providers with National Provider Indicators (NPIs). The National Bureau of Economic Research (NBER) used to convert these to SAS (and other) useful datasetslaunch, but it appears they have stopped, unfortunately.

program description
NPI SAS importget app SAS program to import NPI comma-separated value files (and related reference files). Source files can be found herelaunch under the Full Replacement Monthly NPI File heading. Check the README for the current version the import program supports (I am not updating this monthly, but will try to catch updates with changes to the data structure).

Assorted SAS Macros

Below is a collection of SAS macros I have created or found particularly useful.

program description
SQUEEZEget app SAS program that compresses variable lengths to the minimum necessary, thus decreasing dataset size. Can also be found via the SAS website herelaunch.