topic Re: Extra Text Added to My Sheet Label in ods tagsets.excelxp in ODS and Base Reporting

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

IrishGuy — Thu, 30 Mar 2017 09:43:02 GMT

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 — Thu, 30 Mar 2017 10:28:44 GMT

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 — Thu, 30 Mar 2017 11:12:34 GMT

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.