cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
sasheadache
Obsidian | Level 7 sasheadache
Obsidian | Level 7

Auto re-size column widths when exporting data to Excel

Posted 02-28-2023 08:41 AM (708 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?

0 Likes
Reply

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Watch SAS Enterprise Guide vs. SAS Studio on YouTube

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 0 replies
  • ‎02-28-2023 08:41 AM
  • 709 views
  • 0 likes
  • 1 in conversation