The SAS Output Delivery System and reporting techniques

adjust column widths

Reply
New Contributor
Posts: 3

adjust column widths

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.

Esteemed Advisor
Esteemed Advisor
Posts: 7,232

Re: adjust column widths

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.

New Contributor
Posts: 3

Re: adjust column widths

That seemed to do the trick.  Thank you!

Ask a Question
Discussion stats
  • 2 replies
  • 2309 views
  • 0 likes
  • 2 in conversation