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.