Ksharp's got the closest solution, I think, but there's too many variables and formatting changes inside the metrics to go this route. For example, if I wanted to report a percent in one row and a dollar in the next.
Proc Report works fine for summary reporting, except in this particular instance where ACROSS only groups the variables, rather than stacking them. I'm not sure why that's not an option.
The tabulate options here won't work with formatting, as the output needs to go to ODS and tabulate's formats don't usually carry to ODS and excel unless they're tagattr, then there's limits there too.
Anyway, thanks everyone, I'll have to come up with a new solution.
... View more