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.