Extra Text Added to My Sheet Label in ods tagsets.excelxp

[IrishGuy]

I do a Proc Report and write the report out to Excel as below.

I name the sheet "MyReportA".  However SAS is adding more text to this so the label becomes "My ReportA 1 - Detailed and or summary.....".

Anyone know how to stop this extra text appending onto the label?

ods _all_ close;

ods listing;

ods tagsets.excelxp file="c:\Test.xls";

ods tagsets.excelxp options( sheet_label="MyReportA");

ods _all_ close;

ods listing;

[Ksharp · Accepted solution]

That is really weird.

ods proclabel=' ';

ods tagsets.excelxp file="c:\Test.xls";

ods tagsets.excelxp options( sheet_NAME ="MyReportA");

proc report nowd contents=' ';

[IrishGuy]

That's great thanks.  Its the contents= "" that does the trick.

And if printing multipe reports to multiple tabs then using sheet_name was indeed necessary instead of sheet_label.