Emergency department (ED) utilization serves as a foundational metric across health services research. Because ED visits are high-cost and high-intensity, the identification of these events is critical for measurement and evaluation of healthcare quality(1). Health researchers rely…
The monthly buy-in indicators in the Medicare Master Summary Beneficiary File (MBSF) flag concurrent Medicare and Medicaid enrollment, commonly called “dual eligibility”. It came to my attention that the MBSF indicates an…
When analyzing data for research, it is sometimes necessary to code time windows. In this article we present several examples of programming common administrative healthcare data analytics that involve time in SAS.
A dummy table is a planning tool that approximates data structure. They serve as a practical method of organizing thoughts and expectations before working with data. For analysts, it can take many forms, such as a dataset, a summary table, or even visual chart formats. It can even be an empty…
Medicare beneficiaries may enroll in a private managed care plan (Medicare Advantage (MA)) or in Fee-for-Service (FFS) Medicare (Original Medicare). The Master Beneficiary Summary File (MBSF) includes all beneficiaries enrolled in Medicare for at least one day of the year and contains…
Provider IDs are state-reported variables, meaning that states can include their own provider numbers when submitting records to T-MSIS. In the TAF data, these numbers are delineated by variables with a specific Provider ID suffix.
The TAF Pharmacy files (TAF RX) are a CMS Research Identifiable File (RIF) that contains pharmacy prescription fill and over the counter (OTC) drug information covered by Medicaid. They are sourced from the T-MSIS, which is a repository of service utilization and reimbursement records…
Professional and technical components are HCPCS modifiers that splits Medicare payment into supervision/interpretative and equipment/facility costs. This allows separate entities to bill for their portion of a service.
CMS creates Research Identifiable Files (RIFs) for Encounters and Part D Events by compiling data sent from various Part C (Medicare Advantage) and Part D plan sponsors.
The combination of PROC FORMAT and PROC FREQ can be used to quickly identify missingness, or values that are invalid or not present, in data. Straightforward logic and low line count make this code digestible for both new and experienced SAS programmers.
- Previous page
- Page 2
- Next page