topic Proc report output issue in ODS and Base Reporting

Proc report output issue

nitink26 — Mon, 17 Apr 2023 03:03:16 GMT

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!

Re: Proc report output issue

Ksharp — Mon, 17 Apr 2023 11:37:50 GMT

Re: Proc report output issue

nitink26 — Mon, 17 Apr 2023 23:18:57 GMT

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;

Re: Proc report output issue

Cynthia_sas — Tue, 18 Apr 2023 00:58:58 GMT

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

Re: Proc report output issue

nitink26 — Tue, 18 Apr 2023 08:53:12 GMT

Thanks Cynthia!