percent by row

[hir_7]

I need to convert below table into crosstab. Month would be rows, range would be columns and measure has to be % of balance by row (per month).

I've tried "Percent of Total", but it calculates % of overall total but not % of row total.

Any help is greatly appreciated.

month	range	Count	Balance
Jan-15	<30	18	$              996,958
Jan-15	<60	83	$        324,331
Jan-15	<80	153	$        271,065
Jan-15	<90	91	$        2,761,917
Jan-15	<100	58	$        9,227,751
Jan-15	100+	3	$              995,563

[hir_7 · Accepted solution]

https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-get-crosstab-columns-monthly-to-total-100...

has answered my question.