Pagination when there are wrapping columns using proc report in rtf

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

Pagination when there are wrapping columns using proc report in rtf


Hello,

I've been searching the resulotion without success. I have a listing of adverse events in which some columns need to wrap to different lines depending on records. My codes is like the following:

options nodate nonumber center orientation=landscape topmargin=.5in bottommargin=.5in leftmargin=.7in rightmargin=.7in;

ods listing close;

ods escapechar='^';

ods tagsets.rtf file="c:\temp\testAE.rtf" uniform pagepanels=none style=styles.rtf;

title j=l font='Arial' h=8pt "protocolxxx" j=r "Page ^{thispage} of ^{lastpage}";

footnote j=l font='Arial' h=8pt "testAE.rtf" j=r "&sysdate9 &systime";

proc report nowd nocenter spanrows data=all

style(report)=[frame=void rules=none]

style(header)=[bordertopcolor=black bordertopwidth=1 borderbottomcolor=black borderbottomcolor=black borderbottomwidth=1 background=_undef_ font=(Arial,8pt) testalign=l]

style(column)=[font=(Arial,8pt)];

columns site code id aestr sae start stop actionstr;

define site/order 'site';

define code/order 'Treatment';

define id/order 'Subject';

define aestr/'Adverse Event/Preffered Term/System Organ Class' style(column)=[width=2in];

define sae/'Serious AE/Severity/Relationship' style(column)=[width=1in];

define start/'Start Date' style(column)=[width=1in];

define stop/'Stop Date' style(column)=[width=1in];

define actionstr/'Study Drug Action/Treatment/Outcome' style(column)=[width=1in];

compute after _page_/style=[bordertopcolor=black bordertopwidth=1];

  line ' ';

endcomp;

run;

ods _all_ close;

ods listing;

The pagination of this output is a mess, part of obs listing and '(continued)' line and footer shows the following page. I think this is because of the wrapping. Any advice? Thanks in advance!

Helen


Accepted Solutions
Solution
‎06-17-2012 06:23 PM
Contributor
Posts: 30

Re: Pagination when there are wrapping columns using proc report in rtf

Hi Helen

You'll probably need some kind of pagination macro to do this.

Jiang and Boisvert offer a solution here:

http://www.lexjansen.com/pharmasug/2006/technicaltechniques/tt12.pdf

Regards

Duong

View solution in original post


All Replies
Solution
‎06-17-2012 06:23 PM
Contributor
Posts: 30

Re: Pagination when there are wrapping columns using proc report in rtf

Hi Helen

You'll probably need some kind of pagination macro to do this.

Jiang and Boisvert offer a solution here:

http://www.lexjansen.com/pharmasug/2006/technicaltechniques/tt12.pdf

Regards

Duong

Occasional Contributor
Posts: 7

Re: Pagination when there are wrapping columns using proc report in rtf

Thanks, Duong!

That solution is really great!

(I couldn't find the icon 'answered' anywhere, so I don't know how to change my question status from 'not answered' to 'answered')

(Okay, after I opened using Mozilla  Firefox instead of IE, I saw the icon. Smiley Happy)

Helen

🔒 This topic is solved and locked.

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

Discussion stats
  • 2 replies
  • 423 views
  • 1 like
  • 2 in conversation