I want to output two reports vertically within one Excel worksheet using ods tagsets.excelxp, and apply autofilters on both reports. However when I use ods tagsets.excelxp options(autofilter='all'), only the first report has the autofilter. It doesn't apply to the second report. Is there anyway to have autofilter on both reports? Thanks!
No, this is not possible. Nor is is possible in Excel as far as I am aware. You could export your data to CSV, then have an Excel file with some VBA to read this CSV data and put the result into two Tables each with their own filters. However it is worth mentioning at this point that Excel is not a good data medium, nor is it a reporting enviroment. Perhaps consider what you are doing, and if (there will be) a better way of doing things.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.