Hello. I am brand new to SAS and attempting to create a simplified version of my final product at the moment. My simplified dataset contains 4 columns: The OrderID, the ProductID, the Quantity of each product ordered within the selected order, and the Cost of the product. The OrderID is NOT unique and therefore each order is made up of all the rows containing the same OrderID. I need to find a way to count the number of items in each order (Sum of the quantities over each OrderID) and find the total cost of that order. I have tried endless amounts of code over the last day and everything I use gives me errors in my log. Any help would be greatly appreciated!
... View more
