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