Frequently Asked Questions are used to provide additional information and/or statutory guidance not found in State Medicaid Director Letters, State Health Official Letters, or CMCS Informational Bulletins. The different sets of FAQs as originally released can be accessed below.
Frequently Asked Questions
Per the state drug utilization data table, the "Dataset Views" dropdown selections available are:
- State: State-specific data at the NDC-11 level, for a quarter/year.
- Full Dataset (States + National Totals): A compilation of all the individual state utilization data (50 states plus Washington D.C.) and the National Totals at the NDC-11 level, for a selected year.
- All States: Includes data for all states but does not include the National Totals
- National Totals: Data are aggregated for all 50 states and Washington, D.C. at the NDC-11 level, for a quarter/year.
Since all of the states are combined in the National Totals, the state abbreviation will show on the "Annual State Detail" with a state abbreviation of "XX".
Users can also generate his or her own views of the dataset on data.medicaid.gov.
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?