> One of the issues is that when I group the
> months, its puts them in alpha order-Dec10 Nov10
> rather than month/year order and I am not sure why.
> The dates are legitimate dates.
By default, PROC REPORT orders the values of ORDER and GROUP variables by the formatted value. To order by the unformatted value, add the ORDER=INTERNAL option to the DEFINE statement for that column.
(Don't confuse the ORDER option with the ORDER= option. The ORDER option says to order this column. The ORDER= option says
how to order it.)
See
ORDER=DATA|FORMATTED|FREQ|INTERNAL in the PROC REPORT documentation for the DEFINE statement.