topic Re: ODS TAGSESTS.EXCELXP vs EXCEL Options in ODS and Base Reporting

ODS TAGSESTS.EXCELXP vs EXCEL Options

djbateman — Tue, 30 May 2017 14:40:08 GMT

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?

Re: ODS TAGSESTS.EXCELXP vs EXCEL Options

PaigeMiller — Tue, 30 May 2017 15:14:40 GMT

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

Re: ODS TAGSESTS.EXCELXP vs EXCEL Options

djbateman — Tue, 30 May 2017 17:50:05 GMT

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?

Re: ODS TAGSESTS.EXCELXP vs EXCEL Options

Chevell_sas — Thu, 01 Jun 2017 10:58:03 GMT

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