Line graph (average) with data panel filtered by gender

[Katherine Oleas]

Good afternoon everybody

I need your help. I have a panel database and I want to make a graph of salary evolution but filtered for men and women. Edtoy using the following code, since it is the evolution of the average salary.

line mean time if tag , ytitle( sueldo(units)) legend(order(2))

But I don't know how to filter by man and woman.

[Andrew Musau]

webuse grunfeld, clear
gen tag= company<=6
gen group= company<=3
preserve
collapse invest if tag, by(group year)
tw line invest year if group, sort|| line invest year if !group, sort||, leg(order(1 "A" 2 "B")) xtitle("")
restore

[Katherine Oleas]

Maybe there is another way because I can't use the collapse command, since I am working with a total of 2 million observations and the computer is not very good at running that command

[Andrew Musau]

2 million is by no means large, but I guess large is relative. If you use egen to generate means, you can do so by your grouping variables and tag one observation per group:

bysort female time: egen mean= mean(var)
egen tag= tag(female time)

Then

if tag
if !tag