MCC FY20 Data Cleaning File
The following file provides a step by step demonstration of the process used by MCC's S&E Team to clean all of the raw data files from indicator institutions and create the scorecards. These steps are outlined in MCC's FY20 Guide to the Indicators (https://www.mcc.gov/resources/doc/guide-to-the-indicators-fy-2020) and Data Notes (https://www.mcc.gov/resources/doc/pub-fy2020-scorecard-data-notes) This file is included to provide complete clarity as to exactly how these indicators are constructed.
To use this file, you need to download the appropriate files from the indicator institutions as described below, and set the global macros to the correct locations.
This file will output individual files for each indicator. You can run sections of the program individually, but the section on GNI must be run for the rest to work.
The official final data files are contained on MCC's open data site. The purpose of this file is to provide systematic instructions explaining the methodology used to create these files. Due to methodological changes and historical data revisions by indicator institutions or MCC, this program is not designed to recreate previous year’s scorecards. Rather it is designed to clearly show MCC’s methodology in FY20. Updates will be made annually as needed.
Additional Information
| Field | Value |
|---|---|
| Data last updated | November 12, 2020 |
| Metadata last updated | November 21, 2025 |
| Created | November 12, 2020 |
| Format | |
| License | License not specified |
| Datastore active | False |
| Has views | True |
| Id | 6c2c3118-05fd-46bd-ac95-05ba52c6cbc2 |
| Mimetype | application/pdf |
| Package id | 5bdf02c6-d02b-4c5a-868c-321f89175a0a |
| Position | 32 |
| State | active |