https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-Excel-Dynamic-display-of-row-data/m-p/840823#M25994 /*You could try "AutoFilter" option:*/<BR />ods excel file='c:\temp\temp.xlsx' options(AutoFilter='all');<BR />proc report data=sashelp.class nowd;run;<BR />ods excel close; Wed, 26 Oct 2022 11:36:46 GMT Ksharp 2022-10-26T11:36:46Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-Excel-Dynamic-display-of-row-data/m-p/840704#M25987 <P>I believe it's possible to create an excel spreadsheet from ODS Excel that would allow the end user of the report to collapse or display rows as needed. It would look something like the table below. One user could request to just see the totals by study; or by study and site; or by the study, site and subject by clicking on an object on the spreadsheet. If this is possible, what would need to be added to my proc report code?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Qry_TableJPG.JPG" style="width: 497px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/76609i6757FE9C09B653BB/image-size/large?v=v2&amp;px=999" role="button" title="Qry_TableJPG.JPG" alt="Qry_TableJPG.JPG" /></span></P> Tue, 25 Oct 2022 22:17:55 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-Excel-Dynamic-display-of-row-data/m-p/840704#M25987 JKramer 2022-10-25T22:17:55Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-Excel-Dynamic-display-of-row-data/m-p/840823#M25994 /*You could try "AutoFilter" option:*/<BR />ods excel file='c:\temp\temp.xlsx' options(AutoFilter='all');<BR />proc report data=sashelp.class nowd;run;<BR />ods excel close; Wed, 26 Oct 2022 11:36:46 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-Excel-Dynamic-display-of-row-data/m-p/840823#M25994 Ksharp 2022-10-26T11:36:46Z