Proc report output issue

[nitink26]

Hi,

I am running below code and its running without error.

ods excel file='C:\..\test.xlsx';
proc report data=SASHELP.DEMOGRAPHICS ;
run;
ods excel close;

Only issue I am facing with characters columns have long strings like with column E 

Snapshot below is the excel download-

and if I wrap the text there will be no space between words highlighted in yellow.

Snapshot below after applying Wrap in Excel -

Could you please help me to fix the issue? Thanks!

[Ksharp]

[nitink26]

Hi @Ksharp,

I tried your code but still it removes the spaces between the words.

Snapshot below-

code - 

ods excel file='C:\Nitin\Work\testcolor.xlsx';
proc report data=SASHELP.DEMOGRAPHICS nowd style(column)={tagattr ='wrap:no'};
run;
ods excel close;

[Cynthia_sas · Accepted solution]

Hi:

  Before I try the TAGATTR approach, I will generally try the simple WIDTH= style override for the columns with issues. In this case, with my test of SASHELP.DEMOGRAPHICS, I could generate an Excel report file without wrapping by simply making the width adjustment, as shown below:

  Hope this helps,

Cynthia

[nitink26]

Thanks Cynthia!