topic Re: ods excel file - break in the Excel cell in SAS Programming

ods excel file - break in the Excel cell

Tecla1 — Wed, 08 Apr 2026 15:19:05 GMT

Good afternoon,

I wrote a piece of data that allows me to export to Excel with formatting. However, in the output the text wraps as if the "ALT+ENTER" function in Excel was active. I tried to solve it with "wrap" without success.

Can you help me?

Thank you


ods excel file="prova.xlsx" options
(
   sheet_name="Dati"
    embedded_titles='yes'
    autofilter='yes'
    frozen_headers='yes'
    tab_color='blue'
);

proc report  data=new.prova nowd
    style(report)=[frame=void rules=none width=50%]; 
    define PRESENZA_SOSPESI_SI_NO / style(header)=[background=#009597 foreground=white font_weight=bold]; 
	define INTERVENTI /style(header)=[background=#009597 foreground=white font_weight=bold];
run;

ods excel close;

Re: ods excel file - break in the Excel cell

Kathryn_SAS — Wed, 08 Apr 2026 18:26:25 GMT

Try adding the FLOW='TABLES' suboption as shown below and described in this SAS Note:

KB0039821

ods excel file="prova.xlsx" options
(
   sheet_name="Dati"
    embedded_titles='yes'
    autofilter='yes'
    frozen_headers='yes'
    tab_color='blue'
flow='tables');

Re: ods excel file - break in the Excel cell

Ksharp — Thu, 09 Apr 2026 06:45:47 GMT

proc report  data=new.prova nowd
    style(report)=[frame=void rules=none width=50%]; 
    define PRESENZA_SOSPESI_SI_NO / style(header)=[background=#009597 foreground=white font_weight=bold]; 
	define INTERVENTI /style(column)=[tagattrs="wrap:no"];
run;

Re: ods excel file - break in the Excel cell

Tecla1 — Thu, 09 Apr 2026 08:16:13 GMT

Many Tnks Ksharp! IT's so good !!! have a nice day!!