The SAS Output Delivery System and reporting techniques

ODS TAGSESTS.EXCELXP vs EXCEL Options

Accepted Solution Solved
Reply
Regular Contributor
Posts: 220
Accepted Solution

ODS TAGSESTS.EXCELXP vs EXCEL Options

I'm trying to convert some of my company's standard Excel output options from tagsests.excelxp to ODS EXCEL options.  Everything seems to convert over just fine except for WRAPTEXT and AUTOFIT_HEIGHT.  AUTOFIT_HEIGHT is not too important, but the WRAPTEXT option would be really nice to figure out.  I can't seem to find any wrapping options in the documentation; does anyone know if such an option exists?

 


Accepted Solutions
Solution
‎05-30-2017 11:39 AM
Trusted Advisor
Posts: 1,612

Re: ODS TAGSESTS.EXCELXP vs EXCEL Options


All Replies
Solution
‎05-30-2017 11:39 AM
Trusted Advisor
Posts: 1,612

Re: ODS TAGSESTS.EXCELXP vs EXCEL Options

Regular Contributor
Posts: 220

Re: ODS TAGSESTS.EXCELXP vs EXCEL Options

Thank you for the response.  This worked great to get the text to wrap, but I've noticed that a carriage return is inserted at the wrap.  Is there a way to wrap without that carriage return?

SAS Employee
Posts: 88

Re: ODS TAGSESTS.EXCELXP vs EXCEL Options

There is a new SAS 9.4M4 ODS Excel sub-option FLOW= which will prevent the carriage return characters from being added to the output. Please see the below on the bottom of page 1 for more information.

 

http://support.sas.com/resources/papers/proceedings17/SAS0710-2017.pdf

☑ This topic is SOLVED.

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

Discussion stats
  • 3 replies
  • 204 views
  • 0 likes
  • 3 in conversation