Another ExcelXp Tagset Question - Multiple Sheets ByGroup Issue

[RichardZA]

Hi everyone

I've tried all the online resources I could and I just can't get this to work. I'm using this tutorial as a reference:

http://www2.sas.com/proceedings/forum2008/036-2008.pdf

The issue is that I want my worksheet names to have only the value of the INVSITE variable. Currently I can get it to display on the INVSITE variable value AND the label of the second by group variable PT (also used for the pageby value)

Here is my code

ods tagsets.excelxp file="myreport.xls" style=sansPrinter
	options(sheet_interval='bygroup'
		sheet_label = ' '
		embedded_titles = 'yes' 
		suppress_bylines = 'yes'
		skip_space='0,2,0,1,1'
		Absolute_Column_Width = '14.29,14.86,16.71,14.43,19.86');

	 title #byvar2: #byval2 ;

	  proc print data=mvr_raw4 noobs label   ;
	     by  invsite pt  ;
		 pageby pt;
	  run;
ods tagsets.excelxp close;

My excel tab sheets look like this

100 Subject
101 Subject
227 Subject

Any and all help will be greatly appreciated!

Thanks