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

little_fish — Thu, 31 Oct 2019 02:24:17 GMT

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;

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

unison — Tue, 05 Nov 2019 22:38:26 GMT

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

topic Re: how to print table columns in ods rtf like ods listing in proc report in SAS Programming

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

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