Unix SAS libname xlsx rounds numbers - I don't want it to

[Tom]

---

@PatMalarkey wrote:
I was able to use ODS Excel to write the sheet with the issue to Excel and the percent retains the correct format. I need to write multiple sheets to the workbook, so it's not a complete solution - though I was able to write the other sheets using LIBNAME.

---

So have we now moved away from being worried about the values being wrong and are now talking about how to control the "format" used in to display the numbers in the XLSX file?

[PatMalarkey]

No.  The values are incorrect when I use the LIBNAME method.  They get rounded and they should not be.  ODS is one work-around, but it is less than optimal.

[Reeza · Accepted solution]

ODS EXCEL supports multiple sheets and multiple tables per sheet.

[PatMalarkey]

I see that now!  Thanks!

Link:  https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-excel-multiple-sheet/td-p/225377

[Tom]

---

@PatMalarkey wrote:

No.  The values are incorrect when I use the LIBNAME method.  They get rounded and they should not be.  ODS is one work-around, but it is less than optimal.

---

We have shown that the XLSX engine does not round the sample value you sent.

So if it is still doing that for you (and you are using at least SAS 9.4M5) then open a support ticket with SAS support to have them help debug why your installation is not working.  Perhaps the issue is only triggered with the right combination of data and not just the simple example value you posted.