Data Quality Macros

Pre Data Quality Main Intermediate Post Data Quality Auxiliary Sample Report

- Data Quality: Main Macros -

Main Data Quality Macros

CONTENTS Macro

This macro generates an overview table that contains dataset names, dataset labels, and the number of records and fields for a series of datasets.

VIMO Macro

This macro generates a VIMO table in MS Excel Format for a specific dataset.

LINK Macro

This macro creates a table that shows the number and percentage of linkable records of a specific dataset or list of datasets. If the dataset is a cluster dataset, this macro can be run for a list of cluster members. This macro also generates a distribution table for the phintype variable.

LINKYR Macro

This macro displays the percentage of linkable records over fiscal/calendar year for a specific dataset or a list of datasets.

AGREEMENT Macro

This macro checks the agreement between a list of datasets and registry data for the same individuals and produces Kappa Statistics for sex and date of birth.

TREND Macro

This macro performs a trend analysis over a specified time range, the output is saved in graphic format (.PNG)

REFERENTIAL INTEGRITY CHECK Macro

This macro performs a referential integrity check between two databases. Duplicate or missing primary key and foreign key values found in the foreign table but not in the primary table are identified and the result is summarized in RTF format.

VALIDATION Macro

This macro scans the dataset and counts the number of data inconsistencies based on the validation rules specified by the user. The result is output in RTF format.



Find us on Twitter and Facebook.

MCHP on Twitter MCHP on Facebook