[Jim Callegari]

Thanks for the response Andrew--that's really helpful. I wanted to know if there is a way for me to also stipulate "if" for the "xtline" command. I see in the help section I am allowed to, but it seems like the collapse command limits what I want to do with the "if" command. I want to make separate graphs for

if country=="UK"
if country=="Ireland"

Do you have any idea how I can utilize the collapse command while still maintaining that ability? Thanks so much!

[Andrew Musau]

No beverages in your example, but the following is illustrative:

gen newprod= cond(inlist(prod, "Apples (1 kg)", "Bananas (1 kg)"), "Fruits", "Others ")
encode newprod, gen(product)
preserve
collapse abs_price, by(product year)
xtset product year
xtline abs_price, overlay scheme(s1color) ytitle("Price") xtitle("")
restore