*! version 0.1 16Apr2024

help for metaxl combine

Title

metaxl combine - combines metadata files

Syntax

metaxl combine
, 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.

metafile(fn) saves the combined metadata in the Excel file fn.xlsx.
Defaults to metafile.xlsx.

clean does not export column file#.

replace replaces the combined meta file if it exists.

* required

Description

metaxl combine is a Stata command that combines 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 combines metadata in sheets with the same name found in both files,
eliminating duplicated information. metadata that only appears in one file for
namesake sheets are flagged in the generated metafile. Any row in this
condition will have a value of f1 or f2 in column file#, that indicates
that the information only appears in file f1 or file f2, respectively.

There are cases where more than one column of the type file# may exist. Imagine that
you are combining a file which has already been combined. Sheets in that meta file
already contain a column file1 indentifying the origin of non-common metadata.
So the resulting meta file of the current combination will include a column file2.

Examples

Combine metadata from files meta_auto1.xlsx and meta_auto2.xlsx. Save the combined metadata in meta_comb.xlsx

. metaxl combine, f1(meta_auto1) f2(meta_auto2) meta(meta_comb)

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.

Author

BPLIM, Banco de Portugal, Portugal.

Email: bplim@bportugal.pt

We appreciate your feedback. Comments are welcome!