I have an order transactions data set with one million records. Among the list of order records and variables, there is a GROUP variable which is a classifier and an ITEMS variable which is a numerical integer. My goal is to make a table that displays the top 10 GROUPs with the highest mean ITEMS. I will try to give you an example data set: order_id, group_id, items; 1, A, 6; 2, D, 12; 3, B, 15; 4, A, 10; 5, C, 2; 6, B, 14; 7, F, 4; 8, B, 9; 9, A, 24; 10, D, 12; I imagine I need to use a combination of PROC MEANS, PROC SORT, and PROC PRINT, but I have tried these in combinations with no success.
... View more