Hi!
This code works for me in TAGSETS.EXCELXP to generate the equivalent of the skipped line after the BREAK.
[pre]
proc sort data=sashelp.shoes
out=shoes;
by region;
where region in ('Asia', 'Canada', 'Pacific');
run;
ods listing close;
** Begin Use a Line Statement **************;
** Example: use a line statement to write out;
** a blank line...but by default, the line will be thick;
** and that may be undesirable;
ods tagsets.excelxp file='c:\temp\simskip1.xls' style=sasweb;
title 'Simulate Skip Option 1';
title2 'puts a blank line after region';
proc report data=shoes nowd
style(summary)={font_weight=bold};
column region subsidiary sales;
define region /group;
define subsidiary /group;
define sales / sum;
break after region / summarize;
compute after region /
style(lines)={font_size=1pt cellpadding=0 cellheight=1pt};
line ' ';
endcomp;
run;
ods tagsets.excelxp close;
[/pre]
It seems to me that Excel is ignoring my cellheight (which works quite nicely in HTML output), but since tagsets.excelxp is generating Spreadsheet Markup Language XML, I can live with having the skip there since I can do things in Excel to make the skipped line smaller.
Good luck,
cynthia