topic Re: proc print ods excel width auto in ODS and Base Reporting

proc print ods excel width auto

Nasser_DRMCP — Tue, 18 Jun 2019 16:31:04 GMT

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

Re: proc print ods excel width auto

Reeza — Tue, 18 Jun 2019 16:49:17 GMT

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

Re: proc print ods excel width auto

Cynthia_sas — Wed, 19 Jun 2019 00:17:41 GMT

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