MCHP has developed macros that automate the data quality evaluation process for incoming data. These macros are available for development, use, and distribution under a GNU General Public License.

All macros are written in SAS language with the exception of the AUTOMATE macro (an Excel VBA macro).

In the interest of the continuing development of these macros we encourage you to please share changes and improvements you have made with us. 

Questions and comments can be directed to info@cpe.umanitoba.ca

Data Quality Macros

• Pre Data Quality Macros

• Main Macros

• Intermediate Macro

• Post Data Quality Macro

• Auxiliary Excel VBA Macro

• Instructions on Use

• GNU General Public License v3

Data Quality Documentation

• Sample Report
  A sample generated using the above Data Quality Macros.

• VIMO Table Interpretation
  A document that describes how to read and interpret a VIMO table.

• Data Quality Macros Manual
  Describes the MCHP Data Quality Macros in detail and provides examples of their implementation at MCHP.

• Data Quality Macros Diagram
  Illustrates how the macros integrate with one another and relate to the production of a report.

• Data Quality Framework
  A document that describes and explains the data quality process implemented by MCHP.

• Data Quality Framework Diagram
  An illustration that summarizes the data quality framework at MCHP.

• A Systematic Investigation of Manitoba's Provincial Laboratory Data
  Describes the Acquisition, Data Management, and Data Quality Evaluation processes involved in bringing the Cadham Lab data into the Manitoba Centre for Health Policy's Data Repository.