Hi, I want to extract some information for the table sashelp.shoes in a excel file with the bellow instruction but I also want to filter the column "Product" (second column) for the values "Sandal" and "Boot" and at the end create an excel with all the observations and the table filter by the column "Product"   I want to have all observations but the default view to be one with just Sandal/Boots and if i want in the Excel see the other values for that column   How can I update my program to have all the observations and also included the filter?   ods excel file="C:\Reportes\Testshoes.xlsx" options(sheet_name="Test"); ods excel options (autofilter = 'all'); proc report data=sashelp.shoes; columns _all_; run; ods excel close;   If I update proc report as the bellow line, it's only export the rows with these values, and I need to export all the lines in the excel and selected the filter with these values in the Excel. proc report data=sashelp.shoes(where=(product="Sandal" or product='Boot'));   I have updated my program and now it creates the filter but it's not executed when i open the excel and I don't know how it can be executed in an automatically way by the ods option and also i would like to include in the filter more values as Boot.   ods excel file="C:\Reportes\Testshoes.xlsx" options(sheet_name="Test"); ods excel options (autofilter='2' autofilter_values='Sandal'); proc report data=sashelp.shoes; columns _all_; run; ods excel close;   Thanks in advance for your help ... View more