Graphic with graphs for sub catvars and overall graph

[Martin Semmelberg]

Hello,

I want to create a graphic with multiple graphs for each sub catvar and also a graph that is just the average over all sub catvars. However for the overall graph stata gives me a nonsensical graph. It looks like there are 2 y-values for each x-value.

collapse (mean) wage, by(year sex region) bysort year region (sex): gen wage_ratio= wage[1]/wage[2] twoway line wage_ratio year if region==1 /// || line wage_ratio year if region==2 /// || line wage_ratio year /// I also tried adding "if region==1 | region==2" to the last line.

[Fei Wang]

Martin, you may try the code below (not verified with actual data).

* Start with your original individual level data
expand 2, generate(new)
replace region = 3 if new

collapse wage, by(year sex region)
bysort year region (sex): gen wage_ratio = wage[1]/wage[2]
bysort year region: keep if _n == 1

twoway line wage_ratio year if region == 1 || line wage_ratio year if region == 2 || line wage_ratio year if region == 3, legend(order(1 "region 1" 2 "region 2" 3 "both regions"))