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?
See page 12 here: https://support.sas.com/resources/papers/proceedings16/SAS5642-2016.pdf
See page 12 here: https://support.sas.com/resources/papers/proceedings16/SAS5642-2016.pdf
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?
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.