Hi all,
I've got a problem with reformatting my dataset. I've got multiple observations of the percentage of shares held by an institution (minimum 20) per id (Cusip in my case).
I would like to keep the top 5 of those observations (percentages held by institution) per Cusip and delete all the other observations for that cusip. But I can't find anywhere the command for this.
Is there someone who could help me with this matter?
Thanks in advance,
Geert
I've got a problem with reformatting my dataset. I've got multiple observations of the percentage of shares held by an institution (minimum 20) per id (Cusip in my case).
I would like to keep the top 5 of those observations (percentages held by institution) per Cusip and delete all the other observations for that cusip. But I can't find anywhere the command for this.
Is there someone who could help me with this matter?
Thanks in advance,
Geert
Comment