Example Data set Attached. I have the sum of revenue grouped By 6 groups QTR, Order_No Product_id, Company,State,Vertical. So how do I filter top 10 rows for each group given the data set is sorted by Revenue Descending order . Result would be Top 10 revenues for 6 groups = 60 records How do i change the below query or write new query to achieve this. (Datastep also welcome) Query: PROC SQL; CREATE TABLE Top10 AS SELECT DISTINCT t1.QTR, t1.ORDER_NO, t1.Product_id, t1.Company, t1.STATE, t1.vertical, (SUM(t1.revenue)) FORMAT=DOLLAR15. AS revenue FROM source t1 GROUP BY t1.QTR, t1.ORDER_NO, t1. Product_id, t1. Company, t1.STATE, t1.vertical ORDER BY revenue DESC; QUIT;
... View more