- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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!
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content