Table 2. Analytic File Construction Sequence: Matched Records, by Year and Month.
| Sequence | January | March | ||
|---|---|---|---|---|
|
|
|
|||
| 1999 | 2000 | 2001 | 2001 | |
| Start with M+C Basic Plan Data | 498 Plans | 319 Plans | 352 Plans | 359 Plans |
| Attach Service Area File Data | 2,745 Matched Plan-Counties | 2,031 Matched Plan-Counties | 1,785 Matched Plan-Counties | 1,809 Matched Plan-Counties |
| Attach State/County/Plan File Data | 2,741 Matches | 2,029 Matches | 1,161 Matches | 1,173 Matches |
| Attach Area Resource File Data | 2,737 Matches | 2,027 Matches | 1,159 Matches | 1,171 Matches |
| Attach Risk Scores | 2,737 Matches | 2,027 Matches | 1,159 Matches | 1,171 Matches |
| Append County Dummy Records | 2,737 Plan-County Records and 3,132 County Records | 2,027 Plan-County Records and 3,132 County Records | 1,159 Plan-County Records and 3,129 County Records | 1,171 Plan-County Records and 3,129 County Records |
| Drop Non-M+C Plans or Plans with Missing or Zero Enrollment | 1,865 Plan-County Records and 3,132 County Records | 1,851 Plan-County Records and 3,132 County Records | 1,132 Plan-County Records and 3,129 County Records | 1,136 Plan-County Records and 3,129 County Records |
NOTE: M+C is Medicare+Choice.
SOURCES: Centers for Medicare & Medicaid Services: Data from the Medicare Compare database, Area Resource File, and Quarterly State/County/File: January 1999, 2000, 2001, and March 2001.