Hi, I am facing a problem while applying column widths using ODS with EXCELXP tagset. 1. There are many cloumns(around 40) and I want to increase the cell width for 10, 15 and 30th column only, so that those values fit into the columns.( using autofit_height & absolute_column_width ) I am applying like this: absolute_column_width = ' 4,5,5,4,4,4,4,4,4,30,....40,.............30 '; so like this it is not so efficient so .. the code is : ODS tagsets.ExcelXP PATH='/abcg' FILE="abc.xls" STYLE=xlsansprinter; OPTIONS(autofit_height = 'yes' absolute_column_width = '4,5,5,4,4,4,4,4,4,30,....40,.............30 ' sheet_name = "YTD &g_Year"); PROC report DATA=abc NOWD; COLUMN col1 col2 col3 ...........col30 ; DEFINE col1 / order noprint; DEFINE cat2 / order noprint; : : : DEFINE col10 / order noprint; : : DEFINE col15 / order noprint; : : DEFINE col30 / order noprint; run; ODS _all_ CLOSE; Thanks &Regards Def
... View more