topic Output a dataset with the top obs per group in SAS Enterprise Guide

Output a dataset with the top obs per group

Sean_OConnor — Wed, 31 Jan 2024 10:40:25 GMT

Morning,

I've run a proc summary which has produced a count of values by different groups.

What I would like to do now is take this dataset and output the highest number obs for each group. The issue I'm having is trying to output the top obs per group when there are more than one highest in a group.

For instance there could be only 1 for one group but 3 for another. Any ideas how best to overcome this?

Thanks,

Sean

Re: Output a dataset with the top obs per group

sbxkoenk — Wed, 31 Jan 2024 10:45:59 GMT

4 ways to find the k smallest and largest data values in SAS
By Rick Wicklin on The DO Loop January 26, 2022
https://blogs.sas.com/content/iml/2022/01/26/k-smallest-largest-data.html

In CASL code ... you can use the action simple.topK, which selects the top K and bottom K values for variables in a data set, based on a user-specified ranking order.

Just don't forget to perform all your analyses by-group based !

Koen