ODS Excel - Control Excel option for Data Group

[Gigawatt]

When creating the ODS Excel file I want to be able to "group" columns in the excel file and have the user be able to use the Excel function to expand/collapse the columns to show the grouped columns or not.

Example data All data exists in the dataset and not calculated within the proc report.

Market             Jan          Feb     Mar       Q1    Apr ........     Q4    YTD

A                      10            10        10        30      10               30    120

B                      10            10        10        30      10               30    120

C                      10            10        10        30      10               30    120

When the excel file is opened their is an "outline" created for the grouped data. If the user clicks on the [-] above the columns, the month columns for Jan Feb Mar Apr ....  will "auto hide" and only the Quarterly columns (Q1, Q2 ...) will show. The user can then also clock the plus above the columns to redisplay the months

[Cynthia_sas]

Hi:
That sounds like something you have to do at the Excel end of things with an Excel macro or a VB Script.

Cynthia