I am using the code below to output an Excel file. I am using Sas 8 but I can also use Sas 9. I am using Sas for Unix. I can't figure out how to do three things:
1. Get it to output gridlines instead of solid white background when I open it in Excel. Manually selecting "show gridlines" within Excel tools,options,show gridlines doesn't even work for some reason.
2. Get it to output titles without wrapping text - keep each title on one line, while retaining the specified column widths within the tables below. Right now it's wrapping text and widening the table column below.
3. Change the title color from blue to black. Color=black in the title statement actually increases the font size and doesn't change the color. That seems like a bug. ?
I've searched and searched. Any advice?
ods html file = '/projects/tndcs/regional08/reg_out/purpose 1.xls' style=sasweb;
ods listing close;
ods escapechar="^";
proc report data=sasdata.inv_sub nowindows headline headskip split='*'
style(header)=[font_weight=bold background=ltgray foreground=black];
column iy
(®ION
("Sample Header"
("Total" inv_tot sub_tot pct_sub_tot)
("Under 1" inv_1 sub_1 pct_sub_1)
("Age 1-13" inv_2 sub_2 pct_sub_2)
("Age 14+" inv_3 sub_3 pct_sub_3 ) ) );
define iy / display center 'Cohort|Year' width=10;
[SERIES OF MORE DEFINE STATEMENTS HERE, ALL ARE WIDTH=10]
ods escapechar="^";
title "^S={font_weight=bold font_size=10 pt} Sample Title";
run;
ods html close;
ods listing;
... View more