topic Re: ODS Excel RTL and LTR in SAS Programming

ODS Excel RTL and LTR

DanielDor — Thu, 13 Aug 2020 02:55:42 GMT

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!

Re: ODS Excel RTL and LTR

ChrisNZ — Thu, 13 Aug 2020 04:56:42 GMT

> 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.

Re: ODS Excel RTL and LTR

EyalGonen — Fri, 14 Aug 2020 13:48:34 GMT

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%D7%95%D7%AA-%D7%90%D7%A7%D7%A1%D7%9C-%D7%9E%D7%99%D7%9E%D7%99%D7%9F-%D7%9C%D7%A9%D7%9E%D7%90%D7%9C/gpm-p/645797#M6 maybe you have set the SAS BIDI option to "YES" and that is why you get your Excel file in RTL layout?

HTH,

Eyal

Re: ODS Excel RTL and LTR

DanielDor — Wed, 19 Aug 2020 06:29:41 GMT

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

Re: ODS Excel RTL and LTR

EyalGonen — Wed, 19 Aug 2020 06:50:48 GMT

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

Re: ODS Excel RTL and LTR

EyalGonen — Wed, 19 Aug 2020 07:49:46 GMT

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