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

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 4738 views
  • 2 likes
  • 3 in conversation