Please help insert a column of year having max (ratio)

[Yasutake Homma]

Hello, I need your help.
I have a panel data having corporate code, year and ratios.

I would like to insert a year having maximum PPE/Asset ratio in the stated period sort by corporate code.
Please please help me.

[Jesse Wursten]

bysort corporatecode year: egen max = max(ratio)

[Marcos Almeida]

Please do follow the FAQ advice, particularly the recommendations about sharing data/command/output.

[Yasutake Homma]

>>> Jesse,
Thank you for your advise. If I want to insert a column of "year" of max (ratio), what should I do?

>> Marcos,
Thank you for your advise too.

[Joro Kolev]

>>> Jesse,
Thank you for your advise. If I want to insert a column of "year" of max (ratio), what should I do?

>> Marcos,
Thank you for your advise too.

Good that you are polite and you are thanking everybody, but you are not following the advice that Marcos gave you.

I have no idea what you want, and apparently the shot that Jesse had at what you might want was a miss too.

At this point you can keep on asking the vague question, and we can keep on having random shots at what you might possibly want (or maybe not, if we dont really feel like playing games today), or alternatively

you can look up the help if -dataex-, provide a minimal example of how your data looks like, and then explain how you want the new variable to look like.

[Yasutake Homma]

I am very sorry for my question. I stop asking. I will post more concrete and detail question next time.

[Joro Kolev]

I am very sorry for my question. I stop asking. I will post more concrete and detail question next time.

You keep on being polite but firm in your decision not to provide more information so that we can understand what you want.

Is the following what you want (we can play guessing too if you prefer):

egen  maxratio = max(ratio), by(corporate_code)

gen yearofmaxtemp = year if ratio==maxratio

egen yearofmax = mean(yearofmaxtemp), by(corporate_code)

drop yearofmaxtemp

?

[Yasutake Homma]

Hi Joro, I really appreciate the commands. I resolve my problems I had encountered. Thank you again.