how to keep the highest number within variable x for the ones with same date

[aarony]

hi folks, just had a question popped up on averaging the observations in variable y within the same x's (plz find the attached)

1) how to keep the highest number of directors within the same annual report date of a company?

2) how to average the number of directors within the same annual report date of a company?

[Reeza]

What do you want your output data to look like.

I generally prefer a small sample of data embedded in the question, rather than an attachment (my preference though )

[ballardw]

And do you want a dataset or a report?