topic Re: SAS Excel carriage returns in cells in ODS and Base Reporting

SAS Excel carriage returns in cells

TashaChapWUSS — Tue, 08 Dec 2020 18:06:41 GMT

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?

Re: SAS Excel carriage returns in cells

Tom — Tue, 08 Dec 2020 18:13:15 GMT

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;

Re: SAS Excel carriage returns in cells

Reeza — Tue, 08 Dec 2020 18:13:57 GMT

How are you creating your Excel file?

Re: SAS Excel carriage returns in cells

TashaChapWUSS — Tue, 08 Dec 2020 18:20:47 GMT

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