proc report auto filter ods excel

[Eugenio211]

Hello!  I am using autofilter option in proc report.  however when I filtered the actual report it does not give me my desired output.  is there a way to filter in group?

Current ouputI want to auto filter using the DM column to get the locations under the DMthis is what happens when I filter using the DM column

image 1 is the current output, image 3 is what happens when I filtered using the DM column.  my desired output is that when I filtered using the DM it will also show the locations under the DM's name.

below is what I have coded for the autofilter:

ods excel file="\\pathdirectory\test_List.xlsx"
options(sheet_name='Campaign Summary'
frozen_rowheaders='2'
frozen_headers='4'
autofilter="1-2");

thanks a lot.

[Reeza]

For Excel that means you need your DM column repeated in each column. You could then build a pivot table in this structure, but in this format, Excel will need the row repeated.