ok here is a small attempt to demo.
Not knowing what is really wanted, and how the underlying data are structured, it probably does not hit the mark, but might give an idea
data peterC ;
input agent $ type $ amount ;
list;cards;
1401 npmt .
1401 part 123
1401 over 256
1423 npmt .
1423 npmt .
1423 full 999
1423 part 100
1423 part 115
;
proc tabulate missing formchar='|----|+|---';
class agent type ;
var amount ;
title 'payment type distribution' ;
table agent all, type=' '*pctN
='%' *f= 6.1 all*N*f= 5./rts=11 box=' per-cent by number';
table agent all, type=' '*amount=' ' *pctsum='%' *f= 6.1 all*amount*sum=' '*f= 8./rts=11 box=' per-cent by value';
run;[pre]payment type distribution 16:20 Monday, January 10, 2011 1
---------------------------------------------
| | full | npmt | over | part | All |
|per-cent |------+------+------+------+-----|
|by number| % | % | % | % | N |
|---------+------+------+------+------+-----|
|agent | | | | | |
|---------| | | | | |
|1401 | .| 33.3| 33.3| 33.3| 3|
|---------+------+------+------+------+-----|
|1423 | 20.0| 40.0| .| 40.0| 5|
|---------+------+------+------+------+-----|
|All | 12.5| 37.5| 12.5| 37.5| 8|
---------------------------------------------
payment type distribution 16:20 Monday, January 10, 2011 2
------------------------------------------------
| | full | npmt | over | part | All |
|per-cent |------+------+------+------+--------|
|by value | % | % | % | % | amount |
|---------+------+------+------+------+--------|
|agent | | | | | |
|---------| | | | | |
|1401 | .| .| 67.5| 32.5| 379|
|---------+------+------+------+------+--------|
|1423 | 82.3| .| .| 17.7| 1214|
|---------+------+------+------+------+--------|
|All | 62.7| .| 16.1| 21.2| 1593|
------------------------------------------------
[/pre] and recommend the [ pre ] signals to present results in a fixed pitch for ordinary listing of tables or columns. The best place to find this is at http://support.sas.com/forums/thread.jspa?messageID=27609毙
peterC