A simple search found this example:   https://communities.sas.com/t5/ODS-and-Base-Reporting/Currency-Format-Without-Decimal-Fraction-When-Output-to-Excel-By/td-p/18055   ... View more

Your solution will definitely work. If efficiency is important, this requires writing the output data twice - once to a SAS data set, and again, using PROC EXPORT, to the Excel file. The extra I/O will make this solution less efficient than using the XLSX LIBNAME engine. But if efficiency is not an issue - don't "fix" what isn't broken 😁. All the best, Mark   ... View more

thank you! ... View more