topic Re: ODS in SAS Programming

ODS

epr — Wed, 17 Apr 2013 13:58:10 GMT

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 — Wed, 17 Apr 2013 14:29:30 GMT

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

epr — Wed, 17 Apr 2013 16:02:06 GMT

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

ballardw — Wed, 17 Apr 2013 17:12:21 GMT

What output did you get?

epr — Wed, 17 Apr 2013 17:44:10 GMT

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