ods rtf, MS word table

J_hoon — Wed, 06 Mar 2019 08:27:19 GMT

Hello! everybody!!

I have one question.

I make MS word table, using ods rtf .

But my data set have many columns, so the table of MS word is the table divided two!!!

Like this

It does not matter if the letter is small. Just want to make the table one!!!

Please, Help me!!!!

Re: ods rtf, MS word table

RW9 — Wed, 06 Mar 2019 08:58:20 GMT

First lets clarify semantics. RTF = Rich Text Format, which is a text file with some markup which describe the document. MS Word is not RTF, however it can parse and display RTF, so in this case Word is the Renderer - this is important when thinking about file formats and how they are used as one Renderer may display data differently.

Now your issue with the output splitting, there are numerous ways to increase the space available and change formatting to get it on one table. It depends on your requirements, however bear in mind that a page is only so big and can hold only so much.

to start with you could make the page landscape:

ods orientation=landscape;

... your report code

Second you can modify the style you use to create the output - style templates describe fonts, sizes etc. for the output:

http://support.sas.com/documentation/cdl/en/odsug/65308/HTML/default/viewer.htm#n0we09dlwj2ef1n1fugcur7vn1ck.htm

Third, if you are using proc report then you can set the width of columns, wrap headers (and text) to allow more room. E.g.

proc report data=... nowd split="*";
  columns _all_;
  define subjectnr / "Subj.*Nr." style={cellwidth=1cm};
  ...
run;

So in the style statement (of which you can set all style elements) I set the column width to be 1cm and wrap the heading splitting on the break char *.

From that yu should be able to alter your output to look pretty much anyway you like. Style templates (and graph templates) are very powerful when you get used to them.

topic Re: ods rtf, MS word table in New SAS User

ods rtf, MS word table

Re: ods rtf, MS word table