topic Re: ODS, PROC REPORT in ODS and Base Reporting

ODS, PROC REPORT

deleted_user — Wed, 05 Jul 2006 11:09:51 GMT

I'm trying to create a style sheet for use with PROC REPORT to produce RTF using SAS 9.1.3.

I want my final table to have lines at the top and the bottom of the table but no lines between rows, so am using:

STYLE TABLE FROM CONTAINER /
FRAME = HSIDES
RULES = NONE;

However I do want lines between rows in the header part of the table.
Can someone please help?

Re: ODS, PROC REPORT

Kathryn_SAS — Wed, 05 Jul 2006 11:49:13 GMT

Try the following sample code:

proc template;
define style styles.test;
parent=styles.rtf;
style table from output /
frame=hsides
rules=groups;
style header from headersandfooters /
background=_undef_;
end;
run;

ods listing close;
ods rtf file='test.rtf' style=styles.test;

proc report data=sashelp.class nowd;
run;

ods listing;
ods rtf close;

Re: ODS, PROC REPORT

deleted_user — Wed, 05 Jul 2006 17:39:03 GMT

That doesn't work.

If you change your code to:

proc report data=sashelp.class nowd;
columns ("Line one" name) sex age weight height;
run;

you should be able see what I mean.

Re: ODS, PROC REPORT

Kathryn_SAS — Thu, 06 Jul 2006 11:31:16 GMT

Try the following:

proc template;
define style styles.test;
parent=styles.rtf;
style table from output /
frame=hsides
rules=groups;
style header from headersandfooters /
background=_undef_
protectspecialchars=off;
end;
run;

ods listing close;
ods rtf file='test.rtf' style=styles.test;

proc report data=sashelp.class nowd;
columns ("\brdrb\brdrs\brdrw15 Line one" name) sex age weight height;
run;

ods listing;
ods rtf close;

Re: ODS, PROC REPORT

deleted_user — Fri, 07 Jul 2006 09:32:58 GMT

Hi Kathryn,
That does work, but only after a fashion.
There are "gaps" between the columns. They aren't necessarily visible on screen unless you zoom in to 150%+, but are clearly visible on printed output.

Is there any way of doing this without RTF commands?

Re: ODS, PROC REPORT

Duong — Fri, 25 May 2007 01:44:26 GMT

Hi

\brdrb\brdrs\brdrw15 is like drawing a line in a cell. Note the cells will have a padded gap
otherwise you may run into a situation where text from one cell look as if it is continous
to the next. What you want is to draw the borders - but SAS is not able to do this at the
moment.

You can draw borders by post-processing.

Duong