topic Re: ODS excel style (data) wrap text in SAS Programming

ODS excel style (data) wrap text

zimcom — Fri, 19 Jul 2019 14:06:50 GMT

Good Friday everyone!

I use ODS excel to generate a report, but the text in some of the columns got automatically wrapped like the example below:

Worsening of Congestive
heart failure

Cardiac failure
congestive

Is there a way to control not let the ODS wrap the text, or I can control the width of the columns through style (data)?

Thanks!

Re: ODS excel style (data) wrap text

koyelghosh — Fri, 19 Jul 2019 14:19:35 GMT

May be FLOW='Tables' as an option in ODS Excel will help!! The link is here (http://support.sas.com/kb/59/351.html)

Re: ODS excel style (data) wrap text

koyelghosh — Fri, 19 Jul 2019 14:37:10 GMT

ODS Excel FILE="NameAndPathOfTheFile.xlsx" OPTIONS(FLOW='Tables');
   /* PROC or DATA step here */
ODS Excel Close;

Please let me know, how was the output. I don't have Microsoft Excel to confirm whether it worked or not.

Re: ODS excel style (data) wrap text

zimcom — Fri, 19 Jul 2019 14:54:01 GMT

@koyelghosh

Thank you, the FLOW='Tables' not working for me probably because of the SAS version (I am using SAS 9.4), but I used the "style width = ", and it worked perfect!

Thank you @koyelghosh again and BIG thanks to the entire SAS programming community for the tremendous helps/supports I have been getting throughtout the years!

Re: ODS excel style (data) wrap text

ccabalbag — Mon, 21 Sep 2020 14:14:28 GMT

Hello, Can you elaborate how to use "style with" to unwrapped text?

Thanks.

Re: ODS excel style (data) wrap text

zimcom — Mon, 21 Sep 2020 18:50:17 GMT

first, you need to combine the data using '^n' as below:

CSA = catx('^n', country, sex, age);

then, using the ods option to define the escapechar

options ods escapechar='^';

last, you will have

Country/Sex/Age

Canada
Male
89

I hope this works for you

Re: ODS excel style (data) wrap text

dknochen — Tue, 14 Sep 2021 17:27:26 GMT

flow='tables' worked well, thank you!