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
> 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.
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
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
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.