Just to be clear:
From SAS Add-in in Excel, you import data from a external database into SAS datasets (on the server). Then you open the imported SAS data set for filtering reporting in Excel...?
And now you wish to add a filter to the import part?
I don't have my fingertips on the Add-in right now, but you could create a stored process that does the importing, and there supply a prompt with your desired filter.
... View more