topic Re: ODS EXCEL- There is a missing space when applying a style for certain parts of the title in ODS and Base Reporting

ODS EXCEL- There is a missing space when applying a style for certain parts of the title

Jen579 — Fri, 07 Sep 2018 15:22:39 GMT

Hello,

I want the date in the title to be bold. It works using ^S{} but when I open the Excel file there is a missing space between "by" and the date. I tried different things but I can't make it work. Any ideas?

Thanks!

ods excel file="C:\test.xlsx" options(embedded_titles="Yes");
TITLE1 J=L font='Helvetica' height=14pt "Please submit a completed and update your data, by ^S={font_weight=bold} &sysdate." ;
ods escapechar="^";
proc print data=sashelp.bmt;run;
ods excel close;

Re: ODS EXCEL- There is a missing space when applying a style for certain parts of the title

Reeza — Fri, 07 Sep 2018 14:47:21 GMT

What version of SAS are you using?

I'm on 9.4 TS1M5 and when I run your code it mostly works fine.

There's an error opening the excel file because it has the wrong extension - it should be XLSX.

If you're version is earlier than SAS 9.4TS1M3 then ODS EXCEL was still experimental then.

@Jen579 wrote:

Hello,

I want the date in the title to be bold. It works using ^S{} but when I open the Excel file there is a missing space between "by" and the date. I tried different things but I can't make it work. Any ideas?

Thanks!

ods excel file="C:\test.xls" options(embedded_titles="Yes");
TITLE1 J=L font='Helvetica' height=14pt "Please submit a completed and update your data, by ^S={font_weight=bold} &sysdate." ;
ods escapechar="^";
proc print data=sashelp.bmt;run;
ods excel close;

Re: ODS EXCEL- There is a missing space when applying a style for certain parts of the title

Jen579 — Fri, 07 Sep 2018 15:22:04 GMT

Thanks Reeza. I'm using SAS Enterprise Guide 7.13 HF6.

Do you know if there is any way I can insert a blank space to fix it?

I changed the extension to the file, thanks!

Re: ODS EXCEL- There is a missing space when applying a style for certain parts of the title

Reeza — Fri, 07 Sep 2018 15:29:18 GMT

That doesn't tell us your SAS version.

Run the following to see your version.

proc product_status;run;

Re: ODS EXCEL- There is a missing space when applying a style for certain parts of the title

Jen579 — Fri, 07 Sep 2018 15:31:59 GMT

For Base SAS Software ...
Custom version information: 9.4_M3
Image version information: 9.04.01M3P062415
For SAS/STAT ...
Custom version information: 14.1
For SAS/GRAPH ...
Custom version information: 9.4_M3
For SAS Integration Technologies ...
Custom version information: 9.4_M3
For High Performance Suite ...
Custom version information: 2.2_M4
For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.4_M3
For SAS/ACCESS Interface to ODBC ...
Custom version information: 9.4_M3
For SAS/ACCESS Interface to MySQL ...
Custom version information: 9.4_M3

Re: ODS EXCEL- There is a missing space when applying a style for certain parts of the title

Reeza — Fri, 07 Sep 2018 15:41:35 GMT

So you're on an older version that likely has some bugs still.

Maybe try adding an '09'x -> tab or '0A'x which is a line feed and see if you get spaces or returns?

Re: ODS EXCEL- There is a missing space when applying a style for certain parts of the title

Jen579 — Fri, 07 Sep 2018 15:52:15 GMT

Thank you. I will try that

Re: ODS EXCEL- There is a missing space when applying a style for certain parts of the title

Jen579 — Fri, 07 Sep 2018 16:07:09 GMT

It's not working. I guess I will give up on changing the style. Thank you

Re: ODS EXCEL- There is a missing space when applying a style for certain parts of the title

Cynthia_sas — Fri, 07 Sep 2018 16:31:40 GMT

Hi: Using NBSPACE (both old form and new form) worked for me. I switched the style override for bold to the new form of ESCAPECHAR:

Hope this helps,

Cynthia

Re: ODS EXCEL- There is a missing space when applying a style for certain parts of the title

Jen579 — Fri, 07 Sep 2018 16:56:20 GMT

Thank you Cynthia!