title: Summing observations vertically in SAS by multiple variables
body: <p>I am currently dealing with a data set that includes sales for multiple store locations over the course of 300 weeks. Each week and store combination contains multiple items that need to be summed together. Somehow I need to find the sum of sales for all the items for each week for each store and output that to a data set. I have tried using proc sql, but am unable to sort it by week and store. Any help would be extremely appreciated.</p>