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.
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.
That seemed to do the trick. Thank you!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.