05-30-2017 10:40 AM
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?
05-30-2017 01:50 PM
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?
06-01-2017 06:58 AM
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.
Need further help from the community? Please ask a new question.