topic Re: ODS PDF Equal column width for different tables in ODS and Base Reporting

ODS PDF Equal column width for different tables

AdamD1 — Mon, 26 Oct 2020 10:01:45 GMT

Hi all,

I have a question to improve the visual output of an ODS PDF file.

I'm presenting different tables with PROC REPORT. I could manage to set the width of each table equally. Unfortunately, the columnwidth of both tables are not the same, which looks kinda bad. Is there a way to set the width of each column in each table to one size?

Here is an example code:

ods pdf file="&outpath/example.pdf" style=sapphire startpage=never;
	title "Title";
  proc report data=sashelp.cars style(report)={width=80%};
where MAKE ="Acura";
column Model Origin Type;
run;
proc report data=sashelp.cars style(report)={width=80%};
where MAKE ="Acura";
column EngineSize Horsepower Weight;
run;
ods pdf close;

Thanks in advance.

Re: ODS PDF Equal column width for different tables

andreas_lds — Mon, 26 Oct 2020 10:31:13 GMT

Using a define-statement for every variable, you could set the width of each column. But would not do this, because as soon as you have a variable with more text, unnecessary line breaks will be inserted. And i don't think that all tables with the same width improve the quality of the report at all.

Re: ODS PDF Equal column width for different tables

Ksharp — Mon, 26 Oct 2020 10:43:20 GMT

Try
define model / style={cellwidth=4cm};

Re: ODS PDF Equal column width for different tables

Cynthia_sas — Mon, 26 Oct 2020 14:11:59 GMT

Hi:
When you use PROC REPORT and a DEFINE Statement override, it is better to specify the area in parentheses, like this:
define model / style(column)={width=1in} or
define model/style(header}={background=cyan}
style(column)={color=blue width=1in};

Cynthia