Frequently Asked Questions

You are likely running into a limitation of the program you are trying to use to analyze the data. Microsoft Excel allows 1,048,576 rows of data and many of our datasets exceed this limit.

We recommend users not use Excel for large datasets but instead use another application that can work with datasets of large size (e.g. Microsoft Access).

The Centers for Medicare & Medicaid (CMS) posts updated State Drug Utilization Data (SDUD) according to the following schedule:

• 1st Quarter (plus 5 preceding years of data): Available in August, and includes any late data reporting for 1st Quarter received from States through the end of June, plus any updates to the five preceding years of data.
• 2nd Quarter (plus 5 preceding years of data): Available in November, and includes any late data reporting for 2nd Quarter received from States through the end of September, plus any updates to the 5  preceding years of data.
• *3rd Quarter (update of all preceding years): Available in February, and includes any late data reporting for 3rd Quarter received from States through the end of December, plus any updates to the five preceding years of data.
• 4th Quarter (plus 5 preceding years of data): Available in May, and includes any late data reporting for 4th Quarter received from States through the end of March, plus any updates to the five preceding years of data.

*An update of all preceding years of State Drug Utilization Data (1991 to 3rd Quarter) are posted to the website annually during the month of February. The data posted includes utilization information received from States through the end of December. The National Totals represent aggregate data by NDC-11.

See Also: With regards to State Drug Utilization Data (SDUD), is the data for each quarter's posting always comprehensive?

If the data arrives late, it may miss the quarterly posting. However, it will be included in the next quarter's web posting.

Amounts reimbursed by Medicaid are pre-rebate, not net of rebates.

States are required to submit their utilization data to CMS within 60 days of the end of the rebate period.

Per section 1927 of the Act, initial submissions of quarterly state utilization data are due to CMS within 60 days of the end of each rebate period. If a state fails to report utilization data in the quarter that it was dispensed, the state must submit initial utilization data for the most recently closed quarter as well as adjustments/corrections to any previously reported utilization data.

Drug coverage under Medicaid is an optional benefit for the states. However, if a state opts to cover prescription drugs in their Medicaid program, they must participate in the MDRP.  As part of that participation in the MDRP, states are required to submit quarterly drug utilization data to CMS.  All states and the District of Columbia currently participate in the MDRP; therefore, they all submit quarterly drug utilization data to CMS.

State-only program utilization (e.g. ADAP) should not be included in the Federal State Medicaid Drug Rebate Program.

The drug utilization data that states report to CMS is reported at the NDC level. Therefore, for purposes of the Medicaid Drug Rebate Program (MDRP), crosswalk from HCPCS code to NDC should have already occurred prior to the states reporting their drug utilization data to CMS. Medicare Part B does post a HCPCS to NDC crosswalk ; however, please note that the subset of drugs covered under Part B is much smaller than  the drugs covered under the MDRP. Therefore, you may not find this crosswalk to be all-inclusive of every product covered under the MDRP.

States should identify and exclude 340B claims from 340B providers before submitting their state drug utilization data to CMS.