SAS Excel carriage returns in cells

[TashaChapWUSS]

Hey all,

I'm having this weird issue where my Excel files created with SAS have carriage returns in the middle of the cells.  It's like SAS is determining the column width at some point and then inserting carriage returns instead of true text wrapping.

I'd send over some code, but I'm just using a very basic PROC Print in SAS Studio.  I have a feeling it's a settings issue.  I'm having some vague recollection of a setting I used back when we had EG that prevented this, but I could be making that up entirely.

Has anyone else run across this?

[Tom · Accepted solution]

If you are using ODS EXCEL to make the files then try FLOW="TABLES" option.

https://support.sas.com/kb/59/351.html

/* Using the FLOW="TABLES" Excel suboption */

ods excel file="c:\temp.xlsx" options(flow="tables");

proc print data=sashelp.orsales label;
run;

ods excel close;

[TashaChapWUSS]

YES! Thank you! I knew it was something like that!

For other SAS Studio or EG Users who are just using the default Excel results, if you go into Tools->Options, and then Results->Excel, simply add FLOW="TABLES" in the "Additional tagset options for ODS Excel statement" box

[Reeza]

How are you creating your Excel file?