proc print ods excel width auto

[Nasser_DRMCP]

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

[Reeza · Accepted solution]

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

[Cynthia_sas]

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