The SAS Output Delivery System and reporting techniques

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

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

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;


Accepted Solutions
Solution
‎03-30-2017 07:12 AM
Super User
Posts: 9,854

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

[ Edited ]

That is really weird.

 

ods proclabel=' ';

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

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

proc report nowd contents=' ';

View solution in original post


All Replies
Solution
‎03-30-2017 07:12 AM
Super User
Posts: 9,854

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

[ Edited ]

That is really weird.

 

ods proclabel=' ';

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

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

proc report nowd contents=' ';

Occasional Contributor
Posts: 16

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

[ Edited ]

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.

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 250 views
  • 0 likes
  • 2 in conversation