This code:
=====
/* Get latest copy of tagset from SAS web site */
filename tagset http
'http://support.sas.com:80/rnd/base/topics/odsmarkup/excltags.tpl';
%include tagset / nosource2;
ods tagsets.excelxp file='c:\sas\programs\excelxp\ex5.xls' options(sheet_interval='bygroup' contents='yes');
proc sort data=sashelp.class out=classbysex;
by sex;
run;
proc report data=classbysex nofs missing;
column sex n name age height weight;
define sex / order noprint;
define n / noprint;
break after sex / page;
run;
ods tagsets.excelxp close;
=====
produces a large number (perhaps until the computer runs out of electrons) of error messages:
=====
22976 proc report data=classbysex nofs missing;
22977 column sex n name age height weight;
22978 define sex / order noprint;
22979 define n / noprint;
22980 break after sex / page;
22981 run;
NOTE: Multiple concurrent threads will be used to summarize data.
WARNING: In Event: write_contents_entries, Invalid Expression: do /while $entry_count <= $content_values
WARNING: In Event: write_contents_entries, Invalid Expression: do /while $entry_count <= $content_values
WARNING: In Event: write_contents_entries, Invalid Expression: do /while $entry_count <= $content_values
WARNING: In Event: write_contents_entries, Invalid Expression: do /while $entry_count <= $content_values
WARNING: In Event: write_contents_entries, Invalid Expression: do /while $entry_count <= $content_values
WARNING: In Event: write_contents_entries, Invalid Expression: do /while $entry_count <= $content_values
WARNING: In Event: write_contents_entries, Invalid Expression: do /while $entry_count <= $content_values
WARNING: In Event: write_contents_entries, Invalid Expression: do /while $entry_count <= $content_values
=====
etc.
This happens on Windows, doesn't happen on MVS.
Specifying index='yes' causes an unloadable file to be created. Specifying contents_workbook='all' doesn't cause any errors, but also doesn't create any contents sheets.