*! version 0.1 16Apr2021

help for metaxl cmp

Title

metaxl cmp - compares metadata files

Syntax

metaxl cmp
, f1(fn) f2(fn) [options]

Options
* f1(fn) is the name of the first Excel file where the metadata is stored.

* f2(fn) is name of the second Excel file where the metadata is stored.

export(fn) saves the inconsitencies found by the command in the Excel file fn.xlsx.
Defaults to metacmp.xlsx.

replace replaces the exported Excel file if it exists.

* required

Description

metaxl cmp is a Stata command that compares metadata found in two Excel files.
The command assumes that both Excel files have the structure of the file produced by
metaxl extract.

The program compares both meta files under the assumption that the files should be
identical (the exception being data features) so any difference between them is
labeled as an inconsistency. It searches for inconsistencies in variables, characteristics,
notes and value labels. If any inconsistency is found, a report is produced.

Stored results

metaxl cmp stores the following in r():

Locals

r(inconsistencies) Number of inconsistencies found

Examples

Compare metadata from files meta_auto1.xlsx and meta_auto2.xlsx. Save the report in comp.xlsx

. metaxl cmp, new(meta_auto1) old(meta_auto2) export(comp)

Remarks

Please notice that this software is provided "as is", without warranty of any kind, whether
express, implied, or statutory, including, but not limited to, any warranty of merchantability
or fitness for a particular purpose or any warranty that the contents of the item will be error-free.
In no respect shall the author incur any liability for any damages, including, but limited to,
direct, indirect, special, or consequential damages arising out of, resulting from, or any way
connected to the use of the item, whether or not based upon warranty, contract, tort, or otherwise.

Dependencies

gtools package by Mauricio Bravo

Author

BPLIM, Banco de Portugal, Portugal.

Email: bplim@bportugal.pt

We appreciate your feedback. Comments are welcome!