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
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
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
Thanks for the replay Cynthia.
want a border around the table boundary.
Attached sample.
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
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.