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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.