ODS

Accepted Solution Solved
Reply
Occasional Contributor epr
Occasional Contributor
Posts: 14
Accepted Solution

ODS

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


Accepted Solutions
Solution
‎04-17-2013 10:29 AM
Super Contributor
Posts: 334

Re: ODS

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

View solution in original post


All Replies
Solution
‎04-17-2013 10:29 AM
Super Contributor
Posts: 334

Re: ODS

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

Occasional Contributor epr
Occasional Contributor
Posts: 14

Re: ODS

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

Super User
Posts: 11,343

Re: ODS

What output did you get?

Occasional Contributor epr
Occasional Contributor
Posts: 14

Re: ODS

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 204 views
  • 3 likes
  • 3 in conversation