BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Nasser_DRMCP
Lapis Lazuli | Level 10

hello,

 

I use proc print to display the data of a dataset into an excel file.

my problem is that the first column is too width in excel

thanks in advance for your help

regards

Nasser

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
ODS EXCEL has a column width option you can use to set the width of the columns. Have you tried that option?

View solution in original post

2 REPLIES 2
Reeza
Super User
ODS EXCEL has a column width option you can use to set the width of the columns. Have you tried that option?
Cynthia_sas
Diamond | Level 26

Hi,

  In addition to the option that Reeza mentioned, if it is ONLY the first column and you're using PROC PRINT, then this will work:

ods excel file='c:\temp\diffwidth.xlsx';

proc print data=sashelp.class noobs;
  var sex / 
    style(data)={width=.25in just=c color=navy font_weight=bold};
  var age /
    style(data)={width=.25in just=c color=green font_weight=bold};
  var name height weight;
run;
ods excel close;

As an example of using style overrides.

 

Cynthia

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 4777 views
  • 2 likes
  • 3 in conversation