BookmarkSubscribeRSS Feed
RussellAlmeida
Calcite | Level 5
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
8 REPLIES 8
ScottH_SAS
SAS Employee
I can help but I need to know some more information.

What version and platform are you running SAS ?

Scott
RussellAlmeida
Calcite | Level 5
Hi Scott,

I have SAS 9.1.3 version.

Regards
Russell
RussellAlmeida
Calcite | Level 5
The platform is AIX.
ScottH_SAS
SAS Employee
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
Cynthia_sas
SAS Super FREQ
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
RussellAlmeida
Calcite | Level 5
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
ScottH_SAS
SAS Employee
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;
RussellAlmeida
Calcite | Level 5
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 8 replies
  • 1350 views
  • 0 likes
  • 3 in conversation