Hi, I have several seasonal datasets with the same variables for the same divisions - e.g. Month1 dataset has a column called 'sales' for each divisionXi. I need a SAS macro to add, say, all monthly sales for each division to get a year's total without merging the monthly datasets. Each dataset looks like this; Dataset Mi Division Sales Profit Salary ... Anyone who can help with a macro to create a yearly dataset summing monthly figures? Ray
... View more