proc report auto filter ods excel

Eugenio211 — Fri, 09 Jul 2021 13:50:27 GMT

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.

Re: proc report auto filter ods excel

Reeza — Fri, 09 Jul 2021 15:21:18 GMT

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.

topic Re: proc report auto filter ods excel in SAS Programming

proc report auto filter ods excel

Re: proc report auto filter ods excel