mergemap · gallery_run.tsv
mode: run · layout: vertical · 21 events · 3 of 5 joins flagged: 3 warn
!!
= warning or stop (never colour alone) · dashed box = tempfile · ×N = collapsed loop · #k = journal event · hover a node for detail
mergemap join map for gallery_run.tsv (run mode)
Boxes are datasets in memory or on disk; arrows are joins, filters and saves, top to bottom, in do-file order.
01_cars.do
#1 · 01_cars.do line 13 · save saved to: cars_all.dta in 74 × 14 → out 74 × 14 opts: replace lifecycle: overwrite
#1
cars_all.dta
74 × 14 · [saved, overwrites]
#2 · 01_cars.do line 16 · use file: cars_all.dta out 74 × 14 using 74 × 14 opts: clear lifecycle: read produced by 01_cars.do line 13
#2
cars_all.dta
→ #4 saved: cars_early.dta
[from line 13]
74 × 14
37 × 14 saved
#5 · 01_cars.do line 20 · use file: cars_all.dta out 74 × 14 using 74 × 14 opts: clear lifecycle: read produced by 01_cars.do line 13
#5
cars_all.dta
→ #7 saved: cars_late.dta
[from line 13]
74 × 14
37 × 14 saved
#8 · 01_cars.do line 25 · use file: cars_all.dta out 74 × 14 using 74 × 14 opts: clear lifecycle: read produced by 01_cars.do line 13
#8
cars_all.dta
→ #11 saved: rep_lookup.dta
[from line 13]
74 × 14
5 × 2 saved
#12 · 01_cars.do line 31 · use file: cars_all.dta out 74 × 14 using 74 × 14 opts: clear lifecycle: read produced by 01_cars.do line 13
#12
cars_all.dta
→ #15 saved: price_index.dta
[from line 13]
74 × 14
02_join.do
#16 · 02_join.do line 4 · use file: cars_early.dta out 37 × 14 using 37 × 14 opts: clear lifecycle: read produced by 01_cars.do line 18
#16
cars_early.dta
[from 01_cars.do line 18]
37 × 14
#17 · 02_join.do line 7 · append file: cars_late.dta in 37 × 14 → out 74 × 14 using 37 × 14
#17 append +37 obs → 74 × 14
cars_late.dta
37 × 14
work (after append)
74 × 14
#18 · 02_join.do line 10 · merge m:1 key: rep78 file: rep_lookup.dta in 74 × 14 → out 74 × 15 using 5 × 2 matched 69 · master-only 5 · using-only 0 · missing-updated 0 · conflict-updated 0 cover: 93.2% of master · 100.0% of using types: rep78 int vs int dup-key obs: master 68 · using 0 opts: keep(1 3) nogenerate severity: warn 5 master-only kept
#18 merge m:1 rep78 → 74 × 15
matched 69 · master-only 5 · using-only 0
dup-key obs: master 68 · using 0
cover: 93.2% of master · 100.0% of using
opts: keep(1 3)
!! 5 master-only kept
rep_lookup.dta
5 × 2 · key: rep78
work (after merge)
74 × 15
#19 · 02_join.do line 13 · merge 1:1 key: carid file: price_index.dta in 74 × 15 → out 74 × 16 using 74 × 2 matched 74 · master-only 0 · using-only 0 · missing-updated 0 · conflict-updated 0 cover: 100.0% of master · 100.0% of using types: carid int vs int dup-key obs: master 0 · using 0 opts: nogenerate
#19 merge 1:1 carid → 74 × 16
all 74 matched, 100% of both sides
price_index.dta
74 × 2 · key: carid
#21 · 02_join.do line 19 · save saved to: cars_joined.dta in 69 × 16 → out 69 × 16 opts: replace lifecycle: overwrite
#21
cars_joined.dta
69 × 16 · [saved, overwrites]
03_report.do
#23 · 03_report.do line 6 · save saved to: census_states.dta in 50 × 3 → out 50 × 3 opts: replace lifecycle: overwrite
#23
census_states.dta
50 × 3 · [saved, overwrites]
#24 · 03_report.do line 9 · use file: census_states.dta out 50 × 3 using 50 × 3 opts: clear lifecycle: read produced by 03_report.do line 6
#24
census_states.dta
→ #26 saved: region_totals.dta
[from line 6]
50 × 3
4 × 2 saved
#27 · 03_report.do line 13 · use file: cars_joined.dta out 69 × 16 using 69 × 16 opts: clear lifecycle: read produced by 02_join.do line 19
#27
cars_joined.dta
[from 02_join.do line 19]
69 × 16
#28 · 03_report.do line 14 · merge m:1 key: region file: region_totals.dta in 69 × 16 → out 69 × 17 using 4 × 2 matched 69 · master-only 0 · using-only 0 · missing-updated 0 · conflict-updated 0 cover: 100.0% of master · 100.0% of using types: region byte vs int dup-key obs: master 65 · using 0 opts: keep(1 3) nogenerate severity: warn !! key type drift: region: byte vs int
#28 merge m:1 region → 69 × 17
all 69 matched, 100% of both sides
dup-key obs: master 65 · using 0
!! types: region byte vs int
opts: keep(1 3)
!! key type drift: region: byte vs int
region_totals.dta
4 × 2 · key: region
work (after merge)
69 × 17
#29 · 03_report.do line 19 · merge m:m key: region file: census_states.dta in 69 × 17 → out 69 × 20 using 50 × 3 matched 69 · master-only 0 · using-only 0 · missing-updated 0 · conflict-updated 0 cover: 100.0% of master · 100.0% of using types: region int vs int dup-key obs: master 65 · using 46 severity: warn !! m:m pairs rows by row order within key (not a join)
#29 merge m:m region → 69 × 20
all 69 matched, 100% of both sides
dup-key obs: master 65 · using 46
!! m:m pairs rows by row order within key
(not a join)
census_states.dta
50 × 3 · key: region
#31 · 03_report.do line 22 · save saved to: demo_analysis.dta in 69 × 19 → out 69 × 19 opts: replace lifecycle: overwrite
#31
demo_analysis.dta
69 × 19 · [saved, overwrites]
mergemap · journal gallery_run.tsv · run mode, vertical layout, 21 events · generated 24 Aug 2026 03:01:07 · Stata 19.5 MP · self-contained: no scripts, no external assets