@Errant wrote:
So I've reviewed the original requirements and I misinterpreted the requirements. Ultimately I do need to combine the month output with the yearly average output, but the month output actually needs to look like this:
So technically I'm not calculating an average for the month output. I'm confused about how to get this from the original dataset though.
Part of the problem we are having with your words is that you keep talking about a "yearly average" even though the table displayed does not contain yearly averages, it contains monthly averages (as far as I can tell). Where are the yearly averages in this table?
Then you say "technically I'm not calculating an average for the month" but yet it seems that where you have typed "price" is indeed an average for the month. If it is not a monthly average, the what is "price"?
@Errant, in my opinion, the problem we are having here is not SAS. The table you show is a simple PROC REPORT. The problem which is preventing us from making progress is that your description of the problem has changed multiple times and doesn't seem to match the latest table you are showing us, as far as I can tell.
... View more