|Pre Data Quality||Main||Intermediate||Post Data Quality||Auxiliary||Sample Report|
- Data Quality: Main Macros -
Main Data Quality Macros
This macro generates an overview table that contains dataset names, dataset labels, and the number of records and fields for a series of datasets.
This macro generates a VIMO table in MS Excel Format for a specific dataset.
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.
This macro displays the percentage of linkable records over fiscal/calendar year for a specific dataset or a list of datasets.
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.
This macro performs a trend analysis over a specified time range, the output is saved in graphic format (.PNG)
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.
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.