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