How to identify the largest observation per group

[Saleh sharmah]

Dear members

I have loan data where a firm ( borrower Id) has multiple loans per year and would like to find the largest loan for borrower id in each year . Specifically, I would like to creat a new variable containing only the largest loan amount for each borrower id in a given year for robustness .

would you kindly provide me the code ?

Blessings and thanks for your kind response

[Nick Cox]

I don't know what is robust about selecting the maximum, but

egen max_loan = max(loan) , by(borrower_id year)

should point in a good direction.

(In Stata an observation is a case, record, or row in the dataset. Maximum value is a better term here for what you want.)

[Saleh sharmah]

Dear Nick
as always, thank you for your prompt response and help.

[Saleh sharmah]

Regarding the robustness, the max loan amount per borrower id will be used in a robustness model.

[Nick Cox]

No idea what that means, but that doesn't matter.

[Saleh sharmah]

Hey Nick
a follow up question: so I used your code but the problem is that I only want to have the max loan in a given year per borrower id without duplicating the same amount for the same borrower id in a given year.
thanks

[Nick Cox]

See the tag() function in the help for egen which is designed for precisely this problem.

[Saleh sharmah]

Thank you Nick, it worked now.