BookmarkSubscribeRSS Feed
J_hoon
Calcite | Level 5

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.

 

캡처.PNG

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.

1 REPLY 1
Cynthia_sas
SAS Super FREQ

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.

test_table_rtf.png

Cynthia

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 499 views
  • 0 likes
  • 2 in conversation