ODS TAGSESTS.EXCELXP vs EXCEL Options

[djbateman]

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?

[PaigeMiller · Accepted solution]

See page 12 here: https://support.sas.com/resources/papers/proceedings16/SAS5642-2016.pdf

[djbateman]

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?

[Chevell_sas]

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