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

drug class	description
antiHYPERTENSIVES	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
antiDIABETICS	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.

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 codes	SAS program and accompanying example datasets (for antihypertensives) to extract Multum Lexicon drug codes (d#####) from publicly-available RxNorm fileslaunch.

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-SAS	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).

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 import	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).

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

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