topic Re: Adding Over Line and Under Line in ODS PDF Summary in ODS and Base Reporting

Adding Over Line and Under Line in ODS PDF Summary

RussellAlmeida — Mon, 04 Jan 2010 10:35:48 GMT

Hi,

I would like to add underline and overline on the summary row.

I have example of ods HTML but it does not work for ODS PDF.

Please suggest.

Example
-------------
ods html file='tmep.html';

proc report data=sashelp.class nowd
style(column)={background=_undef_}
style(report)={rules=none frame=void background=_undef_}
style(header)={background=_undef_}
style(summary)={htmlstyle="border-top:solid;border-bottom:solid"};
define age / order;

break after age / summarize ;

run;

ods html close;

Regards
Russell

Re: Adding Over Line and Under Line in ODS PDF Summary

ScottH_SAS — Mon, 04 Jan 2010 15:14:42 GMT

I can help but I need to know some more information.

What version and platform are you running SAS ?

Scott

Re: Adding Over Line and Under Line in ODS PDF Summary

RussellAlmeida — Mon, 04 Jan 2010 21:33:38 GMT

Hi Scott,

I have SAS 9.1.3 version.

Regards
Russell

Re: Adding Over Line and Under Line in ODS PDF Summary

RussellAlmeida — Tue, 05 Jan 2010 08:53:04 GMT

The platform is AIX.

Re: Adding Over Line and Under Line in ODS PDF Summary

ScottH_SAS — Tue, 05 Jan 2010 20:29:24 GMT

Okay after further examination this is not possible with PDF. The reason it works with html is because the overline and underline are being put in as raw HTML.

Scott

Re: Adding Over Line and Under Line in ODS PDF Summary

Cynthia_sas — Wed, 06 Jan 2010 01:34:43 GMT

It may be possible in 9.1.3 to create the HTML file using the CSS technique with HTMLSTYLE. Then, once the HTML file is created, either the full Acrobat or a 3rd party
HTML-to-PDF program might be able to distill the HTML file to PDF with the underline and overline intact.

That would be my idea for 9.1.3.

cynthia

Re: Adding Over Line and Under Line in ODS PDF Summary

RussellAlmeida — Wed, 06 Jan 2010 14:11:14 GMT

I came across a SUGI PDF Document Paper 092-31 from SUIGI 31 which has a code snippet to do what i require, i got in touch with the author but he mentioned that this is possible with SAS 9.2.

Also, I am developing my reports using EG but the will be deploying them as stored process to take necessary parameters. When i run the project on EG apart from the PDF an HTML File is generated with just the SAS Logo, how do i supperess this file from being generated.

Regards
Russell

Re: Adding Over Line and Under Line in ODS PDF Summary

ScottH_SAS — Wed, 06 Jan 2010 14:39:48 GMT

if 9.2 is in play then you can use individual border control with both PDF and HTML. Here is the proc report updated to work in 9.2:

proc report data=sashelp.class nowd
style(column)={background=_undef_}
style(report)={rules=none frame=void background=_undef_}
style(header)={background=_undef_}
style(summary)={bordertopwidth=1px bordertopstyle=solid bordertopcolor=black
borderbottomwidth=1px borderbottomstyle=solid borderbottomcolor=black
borderleftwidth=0 borderrightwidth=0};
define age / order;

break after age / summarize ;

run;

Re: Adding Over Line and Under Line in ODS PDF Summary

RussellAlmeida — Wed, 06 Jan 2010 15:13:31 GMT

Hi Scott,

I was not aware that the example shown in the SUGI document was related to SAS 9.2.

Unfortunately i have SAS 9.1.3 and i believe this option will not work for me.

Regards
Russell