ODS Style format not working

zqkal — Tue, 25 Nov 2014 16:57:24 GMT

I’m creating a title page. Here is how I started. I enter all the information into a sas dataset and then read in the dataset using proc reports and apply style format using call define statement. Somehow it’s not giving me the style format I specified. Does anyone know what I’m doing wrong?

Here is what I want:

1st line: font_size 16, Calibri, Bold, background= Blue ,color=white

2^nd line: font_size 12, Calibri, Blue ,color=white

3^rd line: font_size 12, Calibri, Blue ,color=white

4^th line: font_size 12, Calibri, Blue ,color=white

5^th – 9^th line: font_size 12, Calibri, light Blue ,color=Darkblue

Here is what I have. Can you please help?

ods listing close;

ods escapechar="^";

ods tagsets.ExcelXP

file="&path./&file_name."

style=festival

options(orientation='portrait'

skip_space = '2,0,0,0,0');

%let run_date = %sysfunc(today(),mmddyy10.);

data cover_page;

length line $200. ;

do i= 1 to 28;

if i = 1 then line="Daily report " ;

if i = 2 then line="Version: DM0203: ";

if i = 3 then line="Report Run on:&run_date.";

if i = 4 then line=" ";

if i = 5 then line="List of Views:";

if i = 6 then line=">> Report1 ";

if i = 7 then line=">> Report2 ";

if i = 8 then line=">> Detail1 ";

if i = 9 then line=">> Detail2 ";

output;

drop I;

end;

run;

ods tagsets.excelXP

options(sheet_name='Cover Page'

width_fudge='.0625'

width_points='12'

absolute_column_width='600'

Fittopage='Yes'

skip_space ='2,0,0,0,0'

Pages_FitWidth = '1'

pages_Fitheight = '1'

embedded_titles='Yes'

center_vertical='Yes'

center_horizontal='Yes'

autofit_height='Yes');

title;

proc report noheader nowd data=kdev.cover_page;

column line;

define line /display ' ';

compute line;

rownum= obsno + 1;

if rownum =1 then do;

Call Define(_row_,'STYLE','STYLE={color=white font_face=calibri font_wight=Bold fontfontsize=16 background=#366092}');

end;

if rownum =2 then do;

Call Define(_row_,'STYLE','STYLE={color=white font_face=calibri fontsize=12 background=#366092}');

end;

if rownum =3 then do;

Call Define(_row_,'STYLE','STYLE={color=white font_face=calibri fontsize=12 background=#366092}');

end;

if rownum =4 then do;

Call Define(_row_,'STYLE','STYLE={color=#366092 font_face=calibri fontsize=12 background=#366092}');

end;

if rownum =5 then do;