topic Re: How to define table cell padding for tables with template styles using ODS tagsets.sasreport in SAS Enterprise Guide

How to define table cell padding for tables with template styles using ODS tagsets.sasreport

mathias — Mon, 02 Jul 2018 12:58:55 GMT

Hello,

I'm trying to define my template styles and I cannot increase the table cells padding when output is "ODS tagsets.sasreport13".

style Table /
    cellpadding = 50pt /* ONLY EFFECT HTML, PDF, RTF */
    ;

This code can change the table cells padding but only when output is HTML, PDF and RTF.

I have been trying with these too but they don't change anything

paddingright = 50pt
paddingtop = 50pt
paddingright = 50pt
paddingleft = 50pt
padding = 50pt

HTML:

tagsets.sasreport13:

Using SAS 9.3 and Enterprise Guide 7.1

Re: How to define table cell padding for tables with template styles using ODS tagsets.sasreport

RW9 — Mon, 02 Jul 2018 13:15:54 GMT

Are you talking about Excel output? If so then look at the tagsets.excelxp or excel tipsheets on how to set column widths.

Quite possibly absolute_column_width is the option you are looking for as you can provide a list of columns widths. Its not to do with style.

Re: How to define table cell padding for tables with template styles using ODS tagsets.sasreport

mathias — Mon, 02 Jul 2018 13:19:35 GMT

No this is not excel.

This is the default output of enterprise Guide.

12         ODS _ALL_ CLOSE;
13         OPTIONS DEV=ACTIVEX;
14         GOPTIONS XPIXELS=0 YPIXELS=0;
15         FILENAME EGSR TEMP;
16         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
17             STYLE=xxxxxxxx
18             NOGTITLE
19             NOGFOOTNOTE
20             GPATH=&sasworklocation
21             ENCODING=UTF8
22             options(rolap="on")
23         ;

Re: How to define table cell padding for tables with template styles using ODS tagsets.sasreport

RW9 — Mon, 02 Jul 2018 13:27:08 GMT

And what is the "default output of enterprise Guide. "? Does it create a file, what type? You mention pdf, html, rtf, that really only leaves Excel as a usual output format.

Re: How to define table cell padding for tables with template styles using ODS tagsets.sasreport

mathias — Mon, 02 Jul 2018 13:51:09 GMT

It's a "SAS report", I'm not really sure if that is the most correct name, I thought is was the most common output.

Here are a few screenshots :

Re: How to define table cell padding for tables with template styles using ODS tagsets.sasreport

RW9 — Mon, 02 Jul 2018 14:07:03 GMT

Sorry, not heard of a "sas report", will move the thread to EG area, perhaps the guys who use that can help.