BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sivastat08
Pyrite | Level 9

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

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
Diamond | Level 26

Hi:

  The title is OUTSIDE the table boundary.

title_outside.png

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:

fake_title.png

 

Cynthia

View solution in original post

4 REPLIES 4
Cynthia_sas
Diamond | Level 26

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????

get_rid_cells_or_title.png

 

  But this might give you some ideas:

no_blank_cells.png

 

Cynthia

sivastat08
Pyrite | Level 9

Thanks for the replay Cynthia.

want a border around the table boundary.

Attached sample.

Boundry Border1.jpg

Cynthia_sas
Diamond | Level 26

Hi:

  The title is OUTSIDE the table boundary.

title_outside.png

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:

fake_title.png

 

Cynthia

sivastat08
Pyrite | Level 9
Thank you Cynthia,

The code is working fine.Thanks!

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 5445 views
  • 1 like
  • 2 in conversation