Merge and reshape
Follow each record from its source to the result. Change the keys, sample or layout and see exactly what Stata would retain.
Show a hint
Source tables
Merged result
Interpret this result
Stata commands, interpretation and scope
Reproduce this result
Export the project, open its folder as your Stata working directory,
and run analysis.do. The script imports explicitly
typed columns, performs the operation and writes
native-result.csv. Compare values and keys; display
order can differ.
Supported here: merge 1:1, m:1 and
1:m, ordinary missing values, and
reshape with positive integer suffixes. The native
manuals cover additional syntax and storage types:
merge and
reshape.