Making 1 observations from multiple observations

[Davey Bakker]

Hi,

I'm trying to make a new variable which exists of only unique observations.
In my original dataset I got player transfers (football) with variable player name, selling and buying club, date and fee.
However, multiple transfers have occurred for the same team on some days. Therefore, I want to create a new variable which
aggregates the fees of the transfers on that day and so create only unique (in terms of days) observations.
Could someone help me?

[Nick Cox]

Cross-reference to your earlier thread http://www.statalist.org/forums/foru...vents-on-1-day would be helpful here.

As in that thread, the problem seems to call for collapse or contract, but without a specific dataset example you are unlikely to get more specific code suggestions. But if aggregate means either total or mean, then help collapse is your first port of call.

[Davey Bakker]

Nick Cox collapse was indeed the answer, thanx a lot!