Line graph

[David Dahlgren]

I am trying to produce a graph were I want to describe a value for different age groups. My data is panel data on individual level. The solution I have now is to use the collapse function and have one observation for each age group each year. But instead I want to use the egen function and summarize for each age group each years but still have the data on individual level and not collapse it. I tried to make separate variables for each group each year and the run in in a twoway line graph but were the lines doesn't make sense and are disorganized. How can I solve this?

Thanks!

[George Ford]

try lgraph. it collapses automatically and you can by(age).

also post your graph so we can see the problem.