topic Re: adjust column widths in ODS and Base Reporting

adjust column widths

JamBar — Tue, 28 Apr 2015 15:03:40 GMT

I'm having trouble getting the column widths to adjust. I just want them to extend to the largest column width.

Proc Export;

ods tagsets.excelxp file='c:\temp\table1.xml' style=sasweb

options(embedded_titles='yes'

Autofit_width='yes');

proc print data=work.table1 nooks;

title "Title";

run;

ods _all_ close;

Thanks for any help you can provide.

Re: adjust column widths

RW9 — Tue, 28 Apr 2015 15:10:39 GMT

TBH I don't like using guessing methods so I avoid the autofit, and set widths in my code. This avoids dissapointment in the output when data changes.

ods tagsets.excelxp file='c:\temp\table1.xml' style=sasweb options(embedded_titles='yes');

proc report data=work.table1 nowd;

title "Title";

columns a b c;

define a / style(column)=[cellwidth=3cm];

...

run;

ods _all_ close;

To add, you don't need to supply exact measurements, you can use percentages, but I find if your data is one character in first run, then you get a cell with 200 it really messes your outputs up, so I like fixed output structure.

Re: adjust column widths

JamBar — Tue, 28 Apr 2015 15:12:57 GMT

That seemed to do the trick. Thank you!