Auto re-size column widths when exporting data to Excel

Obsidian | Level 7

Auto re-size column widths when exporting data to Excel

Posted 02-28-2023 08:41 AM (1013 views)

In Excel, if you select an entire worksheet you can then easily auto-size all the columns. However, when you create an Excel file in SAS Studio there doesn't appear to be any capability to re-size columns without defining each width manually.

If memory serves me right a previous update and release in SAS EG allowed this functionality by setting something within the ODS, but so far I have not found a solution for SAS Studio. Can anyone assist?

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Auto re-size column widths when exporting data to Excel

Registration is open

SAS Training: Just a Click Away