Relatively new SAS user (Enterprise Guide 7.1) and programmer in general so thanks in advance for bearing with me.   I am looking to find and flag the top %n of members in a group. My dataset roughly resembles this (but think hundreds of millions of observations): member_ID         Group        Cost   1                            A             $10   2                            A             $8   3                            A             $1   4                            A             $0   5                            B             $15   6                            B             $10   7                            B             $7   8                            C             $13   9                            C             $5   10                          C             $0     I am trying to find the top 5% of members per group and seeing how much they collectively cost. The data set is ordered so that cost is descending per group, so it should be as easy as slicing off the top and flagging them. My example above is bad because you can't get 5% from only a couple observations, but hopefully you get the idea.   This was the code I used before I added group into the mix and it gave me a new dataset with the top 5% of total members successfully.    data top5; do _N_=1 to round(nobs*.05); set my_data_set point=_N_ nobs=nobs; output top5; end; stop; run; ... View more