Hello everyone, My dataset has 40 variables, for simplicity I show 7 of them below: branch state city product model date sale I need to find the average sale of each product and model at any date, which is in the weekly manner. I tries the following code: proc sql; create table average as select product, model, date, mean(sale) as sale_ave from original group by product, model, date; quit; However, I found that this code gives me multiple values as sale_ave for each group of product, model, date. How can I fix this problem to have the real average value of the sale? Thanks,
... View more