The SAS Output Delivery System and reporting techniques

Apply autofilter to both two reports within one worksheet

Reply
Regular Learner
Posts: 1

Apply autofilter to both two reports within one worksheet

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!

Super User
Super User
Posts: 8,380

Re: Apply autofilter to both two reports within one worksheet

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.

Ask a Question
Discussion stats
  • 1 reply
  • 113 views
  • 0 likes
  • 2 in conversation