topic Proc Report : Create Border and Title should be in side Border in ODS and Base Reporting

Proc Report : Create Border and Title should be in side Border

sivastat08 — Tue, 28 May 2019 16:14:49 GMT

Hi ,

I want to create border in SAS Report and Title should be inside of the Border.Can anybody help on getting this.

data example;
input Type $ Color $ Season $ Cost;
cards;
flower purple winter 1000
flower pink spring 2000
;
run;
ods listing;
ods html file='myhtml.htm';
title 'Blank cells under the ACROSS variable';
proc report nowd data=example;
col type color season,cost;
define type / group;
define color / group;
define season / across ' ';
define cost / ' ';
run;
ods html close;

Thanks,

Siva

Re: Proc Report : Create Border and Title should be in side Border

Cynthia_sas — Tue, 28 May 2019 18:23:55 GMT

Hi:

I don't understand what you want:

1) want a border around the title -where it is now- outside of the table boundary

2) move the title -inside- the table boundary (use a COMPUTE block and a LINE statement)

3) get rid of the blank cells under spring and winter????

But this might give you some ideas:

Cynthia

Re: Proc Report : Create Border and Title should be in side Border

sivastat08 — Wed, 29 May 2019 09:16:01 GMT

Thanks for the replay Cynthia.

want a border around the table boundary.

Attached sample.

Re: Proc Report : Create Border and Title should be in side Border

Cynthia_sas — Wed, 29 May 2019 17:50:35 GMT

Hi:

The title is OUTSIDE the table boundary.

There isn't a way to put a border around the entire table and the title the way that you show. You can make the border of the table itself dark but the title always sits outside the table -- the best you can do is put a box around the table and another, separate box around the title.

OR, you can bypass the SAS Title and Footnote statement entirely and just use PROC REPORT for everything with a LINE statement:

Cynthia

Re: Proc Report : Create Border and Title should be in side Border

sivastat08 — Thu, 30 May 2019 09:08:13 GMT

Thank you Cynthia,

The code is working fine.Thanks!