ODS Excel RTL and LTR

[DanielDor]

Greetings,

I have 2 issues wity my ODS Excel:

1. I Would like to export reports using ODS EXCEL From Left-to-Right. In my previous computer, everything worked as expected. In my new computer, all Excel Reports are generated from Right-to-Left without capability to change it. Code below:

ods excel file="C:\Users\daniel\KPIs_Daily_Summary_Export.xlsx" options(sheet_name="QBR_And_CooP" Sheet_Interval='none' embedded_titles="yes" sheet_layout='LTR');

title 'CooP';

proc print data=COOP_FINAL label; run;
ods excel close;

Print Screen below:

2. From some reason, my titles are being printed in way which connect the headers names. This creates a way in which when I do pivot table on the file, I get concatenated names:

Print Screen Below:

Please advise 🙂 @EyalGonen 

Thanks!

D

[ChrisNZ]

>  In my new computer, all Excel Reports are generated from Right-to-Left without capability to change it. 

What's the difference in configuration between the computers? Are Excel and Windows configured identically? As for SAS, run proc options and compare the configurations.

[EyalGonen]

Hi @DanielDor 

About Q1 check out https://communities.sas.com/t5/SAS-Users-Group-in-Israel/%D7%94%D7%A4%D7%A7%D7%AA-%D7%93%D7%95%D7%97... maybe you have set the SAS BIDI option to "YES" and that is why you get your Excel file in RTL layout?

HTH,

Eyal

[DanielDor]

Hi Eyal,

For question 1, i've did as following, and it is working!

%put &sysvlong; /* To validate I have version 9.4M6*/
options bidi=no;

For question 2, any ideas?

Thanks!

Daniel

[EyalGonen]

Hi @DanielDor 

I have no idea about Q2. Perhaps you can try to "force" a line break in the column header by embedding the "ODOA" hex values in the header? Perhaps something like this:

label = "line1 %sysfunc(byte(13))%sysfunc(byte(10)) line2";

I have not tried it

All the best,

Eyal

[EyalGonen]

Daniel, join our local SAS users group in Israel at https://communities.sas.com/t5/SAS-Users-Group-in-Israel/gp-p/Israel for Hebrew related questions