Desktop productivity for business analysts and programmers

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

Reply
Frequent Contributor
Posts: 136

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

[ Edited ]

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:

Image 1.png   

 

 

tagsets.sasreport13:
Image 2.png

 
Using SAS 9.3 and Enterprise Guide 7.1

Super User
Super User
Posts: 9,840

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

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.

Frequent Contributor
Posts: 136

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

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         ;
Super User
Super User
Posts: 9,840

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

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.

Frequent Contributor
Posts: 136

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

[ Edited ]

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 : 

 

image.png

 

image.png

 

image.png

Super User
Super User
Posts: 9,840

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

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

Ask a Question
Discussion stats
  • 5 replies
  • 85 views
  • 0 likes
  • 2 in conversation