Hi,
I am new to SAS and to this group. I have been modifying templates so that they
produce the same output in SAS9.1.3 as they did in SAS8.2. I have used the MSOffice2K
tagset
and have almost got the desired result. The issue that I now have is, I have a
line break after each header h1.
I have defined stylesheets as below:
proc template;
define style audit;
parent=styles.default;
style SystemTitle /
font_size = 10pt
font_weight = bold
foreground = #002288
font_face = Times
Just = L
font_style = Italic;
..
.
.
---- avi.sas is the main program and its below.
ods tagsets.MSOffice2K file='New_output.xls' style=audit
title1 'test1';
title2 'test2';
......
....
...
..
.;
Proc print data=sashelp.class;
Run;
ods tagsets.MSOffice2K close;
When I open the code for the excel sheet (New_output.xls') this is what I see for the entry (Note: I have taken out the tags for h1 below as it is treating it as a header)
h1 class="SystemTitle">test1 h1
h1 class="SystemTitle">test2 h1
...
..
.
In the excel sheet I have a line break between 'test1' and 'test2' and so on.
How can I do away with this? I have spent quiet some time researching this before I have come to take help from the group.
Any advise would be appreciated!
Thanks in advance,
Cool_avi
Message was edited by: Cool_avi