ODS

[epr]

Hello everyone,

Using this code

proc report data=z12 nowd;

column category dallas collin dekalb;

define category /display ;

define dallas/sum;

  define dekalb/sum;

define collin/sum;   

run;

i got output like this

Category          Dallas   Collin    Dekalb

Age_0_10         10         100       45

Age_10_20       10           20     100

Age_20_40        90           80      300

Age_40_plus     67          877     766

Total              177          1080     1200   I would like to include total like this. what should i include in the code.

Thank you in advance

[esjackso · Accepted solution]

If i am remebering correctly after your define statements place:

rbreak after / summarize

if you want lines to break up the table from the totals add ul ol after summarize (under line / over line).

Hope that helps

EJ

[epr]

I tried this, it ran but idid not get right output

[ballardw]

What output did you get?

[epr]

oops my bad,  i did something wrong. I got perfect output with you code EJ. Thank you so much.

Thank you for your input ballrdw.

one small question how to insert that extraword 'Total' in report