The SAS Output Delivery System and reporting techniques

Reset column width in PROC REPORT with tagsets.ExcelXP

Reply
Frequent Contributor
Posts: 102

Reset column width in PROC REPORT with tagsets.ExcelXP

I'm using the ExcelXP tagset, version (SAS 9.1.3, v1.86, 04/15/08)
.
I am creating a workbook with several tabs.

The first tab has only one column, and I set the width with the ABSOLUTE_COLUMN_WIDTH tagset option. This works.

For all the subsequent tabs, I want the first column to be a particular width, but all of the remaining columns to have their widths automatically calculated by the tagset. Is there a way to specify that?

Also, is there a simple formula for converting the column width shown in Excel (after I autofit the columns) to the width value needed by the tagset?
SAS Employee
Posts: 95

Re: Reset column width in PROC REPORT with tagsets.ExcelXP

You can use a style over ride to set the cell width for that column.

define var1 /style={cellwidth='12pt'};

Excel uses points so you should be able to use the size directly without any
conversion.
Ask a Question
Discussion stats
  • 1 reply
  • 113 views
  • 0 likes
  • 2 in conversation