The SAS Output Delivery System and reporting techniques

Adding Over Line and Under Line in ODS PDF Summary

Reply
Contributor
Posts: 33

Adding Over Line and Under Line in ODS PDF Summary

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
SAS Employee
Posts: 50

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

Posted in reply to RussellAlmeida
I can help but I need to know some more information.

What version and platform are you running SAS ?

Scott
Contributor
Posts: 33

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

Posted in reply to ScottH_SAS
Hi Scott,

I have SAS 9.1.3 version.

Regards
Russell
Contributor
Posts: 33

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

Posted in reply to RussellAlmeida
The platform is AIX.
SAS Employee
Posts: 50

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

Posted in reply to RussellAlmeida
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
SAS Super FREQ
Posts: 8,868

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

Posted in reply to ScottH_SAS
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
Contributor
Posts: 33

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

Posted in reply to Cynthia_sas
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
SAS Employee
Posts: 50

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

Posted in reply to RussellAlmeida
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;
Contributor
Posts: 33

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

Posted in reply to ScottH_SAS
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
Ask a Question
Discussion stats
  • 8 replies
  • 230 views
  • 0 likes
  • 3 in conversation