mergemap · gallery_scan.tsv

mode: scan · layout: vertical · 33 events · 1 of 5 joins flagged: 1 warn
!! = warning or stop (never colour alone) · dashed box = tempfile · ×N = collapsed loop · #k = journal event · hover a node for detail · scan mode: row changes are unknown until run
mergemap join map for gallery_scan.tsv (scan 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 9 · sysuse file: auto.dta opts: clear lifecycle: read #1 auto.dta → #2 saved: cars_all.dta #3 · 01_cars.do line 16 · use file: cars_all.dta opts: clear lifecycle: read #3 cars_all.dta #4 · 01_cars.do line 17 · keep if opts: if carid <= 37 #4 keep if carid <= 37 #5 · 01_cars.do line 18 · save saved to: cars_early.dta opts: replace lifecycle: create #5 cars_early.dta [saved, new] #6 · 01_cars.do line 20 · use file: cars_all.dta opts: clear lifecycle: read #6 cars_all.dta #7 · 01_cars.do line 21 · keep if opts: if carid > 37 #7 keep if carid > 37 #8 · 01_cars.do line 22 · save saved to: cars_late.dta opts: replace lifecycle: create #8 cars_late.dta [saved, new] #9 · 01_cars.do line 25 · use file: cars_all.dta opts: clear lifecycle: read #9 cars_all.dta #10 · 01_cars.do line 26 · drop if opts: if missing(rep78) #10 drop if missing(rep78) #11 · 01_cars.do line 27 · collapse key: rep78 opts: (mean) rep_mpg = mpg, by(rep78) #11 collapse (mean) rep_mpg = mpg, by(rep78) #12 · 01_cars.do line 28 · save saved to: rep_lookup.dta opts: replace lifecycle: create #12 rep_lookup.dta [saved, new] #13 · 01_cars.do line 31 · use file: cars_all.dta opts: clear lifecycle: read #13 cars_all.dta #14 · 01_cars.do line 32 · keep vars opts: carid price #14 keep carid price #15 · 01_cars.do line 34 · drop vars opts: price #15 drop price #16 · 01_cars.do line 35 · save saved to: price_index.dta opts: replace lifecycle: create #16 price_index.dta [saved, new] 02_join.do #17 · 02_join.do line 4 · use file: cars_early.dta opts: clear lifecycle: read #17 cars_early.dta #18 · 02_join.do line 7 · append file: cars_late.dta #18 append cars_late.dta work (after append) #19 · 02_join.do line 10 · merge m:1 key: rep78 file: rep_lookup.dta opts: keep(1 3) nogenerate keep(1 3): using-only will be dropped #19 merge m:1 rep78 opts: keep(1 3) keep(1 3): using-only will be dropped rep_lookup.dta key: rep78 work (after merge) #20 · 02_join.do line 13 · merge 1:1 key: carid file: price_index.dta opts: nogenerate #20 merge 1:1 carid price_index.dta key: carid #21 · 02_join.do line 17 · drop if opts: if missing(rep_mpg) #21 drop if missing(rep_mpg) #22 · 02_join.do line 19 · save saved to: cars_joined.dta opts: replace lifecycle: create #22 cars_joined.dta [saved, new] 03_report.do #23 · 03_report.do line 4 · sysuse file: census.dta opts: clear lifecycle: read #23 census.dta #24 · 03_report.do line 5 · keep vars opts: state region pop #24 keep state region pop #25 · 03_report.do line 6 · save saved to: census_states.dta opts: replace lifecycle: create #25 census_states.dta [saved, new] #26 · 03_report.do line 9 · use file: census_states.dta opts: clear lifecycle: read #26 census_states.dta #27 · 03_report.do line 10 · collapse key: region opts: (sum) region_pop = pop, by(region) #27 collapse (sum) region_pop = pop, by(region) #28 · 03_report.do line 11 · save saved to: region_totals.dta opts: replace lifecycle: create #28 region_totals.dta [saved, new] #29 · 03_report.do line 13 · use file: cars_joined.dta opts: clear lifecycle: read #29 cars_joined.dta #30 · 03_report.do line 14 · merge m:1 key: region file: region_totals.dta opts: keep(1 3) nogenerate keep(1 3): using-only will be dropped #30 merge m:1 region opts: keep(1 3) keep(1 3): using-only will be dropped region_totals.dta key: region work (after merge) #31 · 03_report.do line 19 · merge m:m key: region file: census_states.dta severity: warn !! m:m pairs rows by row order within key (not a join) #31 merge m:m region !! m:m pairs rows by row order within key   (not a join) census_states.dta key: region #32 · 03_report.do line 20 · drop vars opts: _merge #32 drop _merge #33 · 03_report.do line 22 · save saved to: demo_analysis.dta opts: replace lifecycle: create #33 demo_analysis.dta [saved, new]
mergemap · journal gallery_scan.tsv · scan mode, vertical layout, 33 events · generated 24 Aug 2026 03:01:02 · Stata 19.5 MP · git main @ 4cea22c · self-contained: no scripts, no external assets