Creating Output Files with ODS for Use by Excel - Exchanging Data Between SAS and Microsoft Excel - page 136

Figure 8.34: Output with Column Widths and Hidden Columns 6, 7, and 8.

I want you to notice here that columns F through H are hidden.

Example 8.16.4 Apply an Excel “AUTOFILTER” to Selected Output Columns
The following code will set the column widths and turn “AUTOFILTER” on for columns 6, 7, and 8. (See
columns “F”, “G”, and “H” below.) AUTOFILTER is an option in Excel that indicates special processing
for an Excel spreadsheet column. The processing features in Excel include showing all values, selecting
rows to show when only some of the values are visible, and hiding unwanted values. Columns set up in
Excel worksheets for the AUTOFILTER processing have an arrow icon in the title row.

Table 8.11: Options Used in Example 8.16.4.

ExcelXP Option Setting in Example Result

ABSOLUTE_COLUMN_WIDTH '4,11,10.5,10,5,8,8,8' Set column widths for each

column.

AUTOFILTER '6-8' Turn on the filtering for columns 6,

7, and 8 in the output Excel
workbook.

Figure 8.35: Using the ExcelXP AUTOFILTER Option to Enhance Several Columns.
ODS TAGSETS.EXCELXP BODY='c:\temp\ExcelXP\shoes4.xml'
OPTIONS(ABSOLUTE_COLUMN_WIDTH='4,19,10.5,10,5,8,8,8'
AUTOFILTER='6-8'
);
PROC PRINT DATA=sashelp.shoes;
RUN;
ODS TAGSETS.EXCELXP CLOSE;