How can I Find the Failed Students in the Data Set in Stata?

[smith Jason]

I have a small dataset as follows, and I want to identify the students who failed the exam. If the student failed, then fail==1, otherwise, fail==0.
The new variable to be created is called F (F=1, suggesting a student failed in the exam).


* Example generated by -dataex-.
clear
input byte (sid fail)
1 0
1 0
1 0
1 1
2 1
2 0
2 0
2 0
3 0
3 0
3 0
3 0
4 0
4 0
4 1
end

Thank you for your Stata code!

[Rich Goldstein]

I don't think I fully understand, but the following appears to do what I think you are asking for:

egen byte F=max(fail), by(sid)

[smith Jason]

Thank you!

[smith Jason]

bys sid: egen F=max(fail) works as well.

[Joro Kolev]

bys sid: egen F=max(fail) works as well.

These are (almost) equivalent syntaxes. The -egen- functions can be used both as

bysort sid: egen F=max(fail)

and as

egen F=max(fail), by(sid)

[smith Jason]

Thank you!