ODS excel style (data) wrap text

[zimcom]

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!

[koyelghosh]

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

[koyelghosh · Accepted solution]

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.

[zimcom]

@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!

[ccabalbag]

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

Thanks.

[zimcom]

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

[dknochen]

flow='tables' worked well, thank you!