Don't want to cut a table in ods rft

J_hoon — Wed, 22 May 2019 01:31:34 GMT

Hi there.

I'm create tables using proc report, and extract it for ods rtf.

But, When I use cellheight= option in style(column), the table was cut.

Like this !!

this is a part of my code.

options orientation=landscape;

ods listing close ;
ods escapechar='^';
ods rtf file="&Save\Table.rtf" 
style=journal BODYTITLE STARTPAGE=YES;

title1 font='Times new roman' height=12pt "Table";
title2 font='Times new roman' height=12pt  "Population: Safety Analysis Set";

proc report data=final  ls=200 nowd headline headskip formchar (2)="_" spacing=1 split='|' missing out=out 
style(report)=[outputWidth=100%]
style(header column lines)=[vjust=c fontsize=10pt font_face='Times New Roman' color=black]
style(header) =[just=c font_weight=medium cellheight=0.97cm font_face='Times New Roman' font_style= ROMAN bordertopcolor=black borderbottomcolor=black bordertopwidth=0.5pt borderbottomwidth=0.5pt background=#BFBFBF]
style(column) =[just=c cellheight=0.6cm];

How can I solve this Problem???

Please, Answer Me 🙂 Thank you.

Re: Don't want to cut a table in ods rft

Cynthia_sas — Wed, 22 May 2019 02:26:15 GMT

Hi:
Without data and without a complete program, nobody can run you code. Many of the options you specify will be completely ignored by ODS RTF, in particular, headline, headskip, spacing formchar are all irrelevant to RTF.

You have style overrides multiple times for header and column and that is just going to cause inheritance resolution issues. Why not have 1 single style override for header and then another one for column, instead of what you show.

If you're using the JOURNAL style, why both setting the background color fo the header to gray? the whole purpose of JOURNAL is to be a black and white style.

Any unit of measure you specify, such as inches or cm for cellheight will be translate into TWIPS for RTF -- or twentieths of a printer's point. I can't really see what you're showing in your screen shot because when I run a version of your code using SASHELP.CLASS, I don't have any height problems.

Cynthia

topic Re: Don't want to cut a table in ods rft in SAS Programming

Don't want to cut a table in ods rft

Re: Don't want to cut a table in ods rft