Hello,
When I use ods html to create xls file, below, the var logfile is a long char string and it wraps in the cell and the column is too narrow, abt 35 when viewed in Excel.
proc print data=all u;
sum realtime / style={htmlstyle="vnd.ms-excel.numberformat:[hh]:mm:ss.00"};
var logfile ;
var stepname ;
var realtime / style={htmlstyle="vnd.ms-excel.numberformat:[hh]:mm:ss.00"};
var obsin obsout varsout stepcnt;
run;
When I use excelxp tagset, as in
ods tagsets.excelxp file=all.xls" style=whatever
options(
sheet_label=' ');
ods tagsets.excelxp options(
sheetname=' ');
proc print label data=all;
sum realtime / style={htmlstyle="vnd.ms-excel.numberformat:[hh]:mm:ss.00"};
var logfile ;
var stepname;
var realtime / style={htmlstyle="vnd.ms-excel.numberformat:[hh]:mm:ss.00"};
var obsin obsout varsout stepcnt;
run;
ods tagsets.excelxp close;
The long char string no longer wraps, but now the column is much too wide, abt 227 in the column width viewed in Excel.
The other column widths are acceptable.
Any ideas?
... View more