how to print table columns in ods rtf like ods listing in proc report

[little_fish]

Hi,

   I have a question, when I try to use ODS rtf and Proc report, if there are two many columns, like col1-col12,  if the page would be only for 6 columns. page 1 would have column1-column6,  page 2 still coulmn1-coulmn6,  … until all the column 1-column 6 print out; it would begin to print coulmn7-column12.

   it would not like ODS listing output,  page 1 would have column1--column6,  page 2 column7---cloumn12,  page3 column1----column6, page4 column7---column12.... etc.

    how do I create the output in ODS RTF, like the ODS listing for tables with many columns.

example:

ods listing close;

options orientation=portrait center topmargin=.25in;

ods rtf file='test.rtf' ;

title "ID specified on Date variable";

title2 "PAGE specified on Price7 variable";

proc report data=sashelp.pricedata(obs=30) nowd;

column date price1-price12;

define date / order id;

define price7 / page;

run;

ods rtf close;

ods listing;

[unison]

Hi little_fish,

I'd recommend taking a look at this paper: https://www.pharmasug.org/proceedings/2018/QT/PharmaSUG-2018-QT01.pdf

It outlines a method to utilize Microsoft word to help determine line breaks for better pagination than ods rtf provides.

-unison